<?php
    set_time_limit(0);

    //$true_path = dirname(dirname(dirname(__FILE__)));
    header("Content-type:text/html;charset=utf-8");
    require_once "./sydw_config.php";
    require_once "./search_config.php";
	//连库文件
	require_once "../../sql_connect/common.inc.php";
	require_once "../../sql_connect/common.func.php";
    $conn = $db_connect['vote'];
error_reporting(0);
//ini_set("display_errors","on");
	try{
		$pdo =new PDO("mysql:host=".$conn['dbhost'].";dbname=".$conn['dbname']."","".$conn['dbuser']."","".$conn['dbpwd']."",array(PDO::ATTR_PERSISTENT => true));
        $pdo->query('set names gbk');
    }catch(Exception $e){
		die('mysql connect error!');
	}
	
    $search_api = new search_api();

    $redis = new Redis();
    $redis->connect('fenxiao-redis.redis.rds.aliyuncs.com','6379');
    $redis->auth('JD20fjsl3029kK');
    $redis->select(0);

    $province = !empty($_GET['province'])?$_GET['province']:'';
    $city = !empty($_GET['city'])?$_GET['city']:'';
    $keywords = !empty($_GET['keywords'])?$_GET['keywords']:'';
    $page = !empty($_GET['page'])?$_GET['page']:1;
    $province = test_input($province);
    $city = test_input($city);
    $keywords = test_input($keywords);
    $page = test_input($page);
    //print_r($_GET);exit;
    /*判断来源url，结尾不是“/”线则增加*/
    $_url = $_SERVER["REQUEST_URI"];
    if(!strpos($_url,'html')){
        if(substr($_url,-1)!='/'){
            header('HTTP/1.1 301 Moved Permanently');
            header("location:".$_url."/");
        }
    }
    //获取传参数量
    $count_num = count($_GET);
    if($count_num==2){
        /*验证链接是否在数组里面*/
        $str = "http://bj.huatu.com".$_url."";
    }elseif($count_num==3){
        /*验证链接是否在数组里面*/
        if($page>=1){
            $str = "http://bj.huatu.com/".$province."/".$city."/";
        }else{
            $str = "http://bj.huatu.com/".$province."/".$city."/".$keywords."/";
        }
    }elseif($count_num==4){
        /*验证链接是否在数组里面*/
        $str = "http://bj.huatu.com/".$province."/".$city."/".$keywords."/";
        $page = $page;

    }
    $go_url = '';
    /*验证url*/
    foreach ($province_arr['other'] as $key =>$value){
        if($value['url']==$str){
            //header('HTTP/1.1 301 Moved Permanently');
            //header('location:'.$str.'');
            $go_url = $str;break;
        }
    }

    foreach ($province_arr['have'] as $key =>$value){
        if($value['url']==$str){
            $go_url = $str;break;
        }
    }
    if($go_url!=''){
        header('HTTP/1.1 301 Moved Permanently');
        header('location:'.$str.'');
        exit;
    }


    $arr_info = [];
    $url='';
    foreach ($province_arr['add'] as $key =>$value){
        if($value['url']==$str){
            $url = $value['url'];
            $arr_info = $value['info'];
        }
    }
    $res_dq = [];
    $topid = '';
    $key= '';
    $title= '';
    $description= '';
    $kw= '';
    $channel2= '';
    $channel1= '';
    $channel3= '';
    $zhaokao= '';
    $beikao= '';
    $shiti= '';
    $suipian1= '';
    $suipian2= '';
    $suipian3= '';
    $suipian4= '';
    $suipian5= '';
    $suipian6= '';
    $suipian7= '';
    $suipian8= '';
    $suipian9= '';
    $suipian10= '';
    $style1= '';
    $style2= '';

    //print_r($arr_info);exit;
    if(!empty($arr_info)){
        $topid = $arr_info['topid'];
        $key= $arr_info['key'];
        $title= $arr_info['title'];
        $description= $arr_info['description'];
        $kw= $arr_info['keywords'];
        $channel2= $arr_info['channel2'];
        $channel1= $arr_info['channel1'];
        $channel3= $arr_info['channel3'];
        $zhaokao= $arr_info['zhaokao'];
        $beikao= $arr_info['beikao'];
        $shiti= $arr_info['shiti'];
        $suipian1= $arr_info['suipian1'];
        $suipian2= $arr_info['suipian2'];
        $suipian3= $arr_info['suipian3'];
        $suipian4= $arr_info['suipian4'];
        $suipian5= $arr_info['suipian5'];
        $suipian6= $arr_info['suipian6'];
        $suipian7= $arr_info['suipian7'];
        $suipian8= $arr_info['suipian8'];
        $suipian9= $arr_info['suipian9'];
        $suipian10= $arr_info['suipian10'];
        $style1= $arr_info['style1'];
        $style2= $arr_info['style2'];
        //获取所有栏目三
        
        $redis->delete('bj_diqu'.PROVINCE.$channel1.'新增'.$channel2);
        $bj_diqu = $redis->get('bj_diqu'.PROVINCE.$channel1.'新增'.$channel2);
        if(!empty($bj_diqu)){
            $res_dq = $bj_diqu;
        }else{
            //echo "select url,channel3 from daohang_fenxiao where diqu='".PROVINCE."' AND channel2='".$channel2."' and leixing='新增'";exit;
            $sql_dq = $pdo->query("select url,channel3 from daohang_fenxiao where diqu='".iconv('UTF-8','GBK',PROVINCE)."' AND channel2='".iconv('UTF-8','GBK',$channel2)."' and leixing='".iconv('UTF-8','GBK','新增')."' and channel1='".iconv('UTF-8','GBK',$channel1)."'");
            $res_dq = $sql_dq->fetchAll();
            //echo "select url,channel2 from daohang_fenxiao where diqu='".PROVINCE."' AND leixing='新增' and channel1='".$channel1."'";exit;

            if(empty($res_dq)){
                $sql_dq = $pdo->query("select url,channel2 from daohang_fenxiao where diqu='".iconv('UTF-8','GBK',PROVINCE)."' AND leixing='".iconv('UTF-8','GBK','原有')."' and channel1='".iconv('UTF-8','GBK',$channel1)."'");
                $res_dq = $sql_dq->fetchAll();
            }
            $redis->set('bj_diqu'.PROVINCE.$channel1.'新增'.$channel2,$res_dq);
            $pdo = null;
        }


    }else{
		header('HTTP/1.1 404 Not Found');
        //header('location:http://bj.huatu.com/404.html');
		exit;
    }
    //echo file_get_contents("../../templets/default/beijing/suipian2018/arc_top.htm");
    $channel1_url ='';
    $channel2_url ='';
    foreach ($province_arr['have'] as $k=>$v){
        if($v['channel1']==$channel1 && $v['channel2']=='' && $v['channel3']==''){
            $channel1_url =$v['url'];
        }
        if($v['channel1']==$channel1 && $v['channel2']==$channel2 && $v['channel3']==''){
            $channel2_url =$v['url'];
        }
    }


    /*查询页面信息*/
    /*获取主干列表64条*/
    $params = [
        'index' => $search_api->index,
        'type' => $search_api->type,
        'terminate_after'=>2000,
        'preference' => '123',
        'body' =>  [
            'query' => [
                'bool' => [
                    'must' => [
                        [
                            'match_phrase' => [
                                'host' => "bj.huatu.com",
                            ]
                        ],
                    ]

                ]
            ],
            "sort"=> [  "pubdate"=> [ "order"=> "desc" ] ]
        ],
        'from'=>0,
        'size'=>64
    ];
    /*判断是否为多个id*/
    $data_typid = explod_keys($topid,',','parentids');
    if(strpos($topid,',')){
        $params['body']['query']['bool']['must'][]['bool']['should']=$data_typid;
    }else{
        $params['body']['query']['bool']['must'][]= $data_typid;
    }
    /*判断搜索词是否为多个搜索词*/
    $data_title = explod_keys($key,',','title');
    if(strpos($key,',')){
        $params['body']['query']['bool']['must'][]['bool']['should']=$data_title;
    }else{
        $params['body']['query']['bool']['must'][]=$data_title;
    }

    $total = $search_api->total($params);
    //print_r($params);exit;
    //echo $total;exit;
    $pagesize = 64;
    $total = $total > 10*$pagesize ? 10*$pagesize : $total;
    $total_page = ceil($total/$pagesize);
    //$params['from'] = ($page-1)*$pagesize;
    //$params['size'] = $pagesize;
    $fenye = GetPageList($page,$total,$pagesize,$listsize=2,$listitem='index,end,pre,next,pageno,info',$hidenform='');

    $info = $search_api->search($params);
    //print_r($params);exit;

    /*获取主干2条，按照点击数排序*/
    $params_click = [
        'index' => $search_api->index,
        'type' => $search_api->type,
        'terminate_after'=>2000,
        'preference' => '123',
        'body' =>  [
            'query' => [
                'bool' => [
                    'must' => [
                        [
                            'match_phrase' => [
                                'host' => "bj.huatu.com",
                            ]
                        ]
                    ]

                ]
            ],
            "sort"=> [  "click"=> [ "order"=> "desc" ] ]
        ],
        'from'=>0,
        'size'=>2
    ];
    /*判断是否为多个id*/
    $data_typid = explod_keys($topid,',','parentids');
    if(strpos($topid,',')){
        $params_click['body']['query']['bool']['must'][]['bool']['should']=$data_typid;
    }else{
        $params_click['body']['query']['bool']['must'][]= $data_typid;
    }
    /*判断搜索词是否为多个搜索词*/
    $data_title = explod_keys($key,',','title');
    if(strpos($key,',')){
        $params_click['body']['query']['bool']['must'][]['bool']['should']=$data_title;
    }else{
        $params_click['body']['query']['bool']['must'][]=$data_title;
    }

    $info_click = $search_api->search($params_click);
    $mathZk = [
        'match_phrase' => [
            'parentids' => $zhaokao,
        ]
    ];
    $zhaokao = explode(',',$zhaokao);
    if(count($zhaokao)>1){
        $shitiNew = [];
        foreach ($zhaokao as $k){
            $zhaokaoNew[]= [
                'match_phrase' => [
                    'parentids' => $k,
                ]
            ];
        }

        $mathZk = [
            'bool' => [
                'should'=>$zhaokaoNew
            ],
        ];
    }
    /*获取招考、备考、试题*/
    $param_zk = [
        'index' => $search_api->index,
        'type' => $search_api->type,
        'terminate_after'=>2000,
        'preference' => '123',
        'body' =>  [
            'query' => [
                'bool' => [
                    'must' => [
                        [
                            'match_phrase' => [
                                'host' => "bj.huatu.com",
                            ]
                        ],
                        $mathZk
                    ]

                ]
            ],
            "sort"=> [  "pubdate"=> [ "order"=> "desc" ] ]
        ],
        'from'=>0,
        'size'=>10
    ];
    //print_r($param_zk);
    /*判断搜索词是否为多个搜索词*/
    /*$data_title = explod_keys($key,',','title');
    if(strpos($key,',')){
        $param_zk['body']['query']['bool']['must'][]['bool']['should']=$data_title;
    }else{
        $param_zk['body']['query']['bool']['must'][]=$data_title;
    }*/
    //print_r($param_zk);
    $info_zhaokao = $search_api->search($param_zk);


    $mathBk = [
        'match_phrase' => [
            'parentids' => $beikao,
        ]
    ];
    $beikao = explode(',',$beikao);
    if(count($beikao)>1){
        $beikaoNew = [];
        foreach ($beikao as $k){
            $beikaoNew[]= [
                'match_phrase' => [
                    'parentids' => $k,
                ]
            ];
        }

        $mathBk = [
            'bool' => [
                'should'=>[
                    $beikaoNew
                ]
            ],
        ];
    }
    /*获取备考*/
    $param_bk = [
        'index' => $search_api->index,
        'type' => $search_api->type,
        'terminate_after'=>2000,
        'preference' => '123',
        'body' =>  [
            'query' => [
                'bool' => [
                    'must' => [
                        [
                            'match_phrase' => [
                                'host' => "bj.huatu.com",
                            ]
                        ],
                        $mathBk
                    ]

                ]
            ],
            "sort"=> [  "pubdate"=> [ "order"=> "desc" ] ]
        ],
        'from'=>0,
        'size'=>10
    ];
    /*判断搜索词是否为多个搜索词*/
    /*$data_title = explod_keys($key,',','title');
    if(strpos($key,',')){
        $param_bk['body']['query']['bool']['must'][]['bool']['should']=$data_title;
    }else{
        $param_bk['body']['query']['bool']['must'][]=$data_title;
    }*/
    $info_beikao = $search_api->search($param_bk);
    //print_r($info_beikao);exit;
    $mathSt = [
        'match_phrase' => [
            'parentids' => $shiti,
        ]
    ];
    $shiti = explode(',',$shiti);
    if(count($shiti)>1){
        $shitiNew = [];
        foreach ($shiti as $k){
            $shitiNew[]= [
                'match_phrase' => [
                    'parentids' => $k,
                ]
            ];
        }

        $mathSt = [
             'bool' => [
                  'should'=>[
                      $shitiNew
                  ]
             ],
        ];
    }
    /*获取备考*/
    $param_st = [
        'index' => $search_api->index,
        'type' => $search_api->type,
        'terminate_after'=>2000,
        'preference' => '123',
        'body' =>  [
            'query' => [
                'bool' => [
                    'must' => [
                        [
                            'match_phrase' => [
                                'host' => "bj.huatu.com",
                            ]
                        ],
                        $mathSt
                    ]

                ]
            ],
            "sort"=> [  "pubdate"=> [ "order"=> "desc" ] ]
        ],
        'from'=>0,
        'size'=>10
    ];
    /*判断搜索词是否为多个搜索词*/
    /*$data_title = explod_keys($key,',','title');
    if(strpos($key,',')){
        $param_st['body']['query']['bool']['must'][]['bool']['should']=$data_title;
    }else{
        $param_st['body']['query']['bool']['must'][]=$data_title;
    }*/
    $info_shiti = $search_api->search($param_st);
//print_r($info_shiti);exit;


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />
    <meta name="format-detection" content="telephone=no">
    <title><?php echo $title;?></title>
    <meta name="keywords" content="<?php echo $kw;?>" />
    <meta name="description" content="<?php echo $description;?>" />
    <link rel="stylesheet" type="text/css" href="<?php echo $style1;?>"/>
    <link rel="stylesheet" type="text/css" href="<?php echo $style2;?>"/>
    <!--总部文章页统一调用js文件，不要删除-->
    <script src="http://www.huatu.com/images/2018css/2018zbtylist.js"></script>
    <base target="_blank" />
</head>
<body>
<!--头部 -->
<?php $suipian1 = file_get_contents("../../templets/default/".$suipian1);echo iconv('GBK','UTF-8',$suipian1);?>
<!--头部end-->
<?php $suipian2 = file_get_contents("../../templets/default/".$suipian2);echo iconv('GBK','UTF-8',$suipian2);?>

<?php $suipian3 = file_get_contents("../../templets/default/".$suipian3);echo iconv('GBK','UTF-8',$suipian3);?>

</div>
<?php $suipian4 = file_get_contents("../../templets/default/".$suipian4);echo iconv('GBK','UTF-8',$suipian4);?>

<div class="clear"></div>
<div class="articleBox">
    <div class="crumbsNavline"><div class="crumbsNav Width">您当前位置： <a href='http://bj.huatu.com/' target='_self'>北京人事考试网</a> > <a href='<?php echo $channel1_url;?>' target='_self'><?php echo $channel1;?></a> > <a href='<?php echo $channel2_url;?>' target='_self'><?php echo $channel2;?></a> > <a href='<?php echo $url;?>' target='_self'><?php echo $channel3;?></a> > </div></div>
    <div class="Width">
        <div class="artBox_left">
            <div class="fxlist_tit">
                <h1><span><?php echo $channel2;?></span></h1>
                <p>
                    <?php

                        $tmp='';
                        foreach ($res_dq as $key =>$value){
                            $tmp.="<a href='".$value['url']."' title='".iconv('GBK','UTF-8',$value['channel3'])."'><span>".mb_substr(iconv('GBK','UTF-8',$value['channel3']),0,4,'UTF-8')."</span></a>";
                        }
                        echo $tmp;
                        $pdo = null;
                    ?>

                </p>
            </div>
            <div class="fxlist_recom">
                <ul>
                    <?php
                        $tmp='';
                        foreach ($info_click as $key =>$value){
                           // $tmp.="<li><a href='".$value['url']."' ><em>推荐</em> ".$value['title']."</a><span>[".$value['click']."人浏览]   ".date('y-m-d',$value['pubdate'])."</span></li>";
                        }
                       // echo $tmp;
                    ?>
                </ul>
            </div>

            <div class="fxlist_Conday">
                <ul>
                    <?php
                        //print_r($info);
                        $tmp='';

                        foreach ($info as $k=>$v){
                            if($k<2){
                                $tmp.='<li><time><font color="#f22a2e">'.date('m-d',$v['pubdate']).'</font></time><mark>'.$v['click'].'人浏览</mark><cite><a href="'.$url.'">'.$channel3.'</a>&nbsp;&nbsp;|&nbsp;&nbsp;</cite><a href="'.$v['url'].'">'.$v['title'].'</a></li>';
                            }else{
                                $tmp.='<li><time>'.date('m-d',$v['pubdate']).'</time><mark>'.$v['click'].'人浏览</mark><cite><a href="'.$url.'">'.$channel3.'</a>&nbsp;&nbsp;|&nbsp;&nbsp;</cite><a href="'.$v['url'].'">'.$v['title'].'</a></li>';
                            }
                            if(($k+1)%8==0){
                                $tmp.='<br/>';
                            }
                        }
                        echo $tmp;
                    ?>

                    <br />
                </ul>

            </div>

            <div class="coursePage">
                <!--<li><a>首页</a></li>
                <li class="thisclass"><a>1</a></li>
                <li><a href='2.html' target='_self'>2</a></li>
                <li><a href='3.html' target='_self'>3</a></li>
                <li><a href='4.html' target='_self'>4</a></li>
                <li><a href='5.html' target='_self'>5</a></li>
                <li><a href='2.html' target='_self'>下一页</a></li>
                <li><a href='24.html' target='_self'>末页</a></li>
                <li><span class="pageinfo">共 <strong>24</strong> 页<strong> 1511</strong> 条</span></li>-->
                <?php echo $fenye;?>
            </div>
        </div>
        <div class="artBox_rig">
            <form action="http://so.huatu.com/index/search/search.html" target="_blank">
                <input type="text" placeholder="<?php echo $channel1;?>" name="q">
                <input type="submit" value="">
            </form>
            <?php $suipian5 = file_get_contents("../../templets/default/".$suipian5);echo iconv('GBK','UTF-8',$suipian5);?>

            <?php $suipian6 = file_get_contents("../../templets/default/".$suipian6);echo iconv('GBK','UTF-8',$suipian6);?>

            <div class="artBox_rinfo">
                <div class="artBox_rkcnum">
                    <a class="cur" href="http://bj.huatu.com/gwy/kaoshi/">招考信息</a>
                    <a href="http://bj.huatu.com/gwy/ziliao/">备考资料</a>
                    <a href="http://bj.huatu.com/gwy/ziliao/">试题资料</a>
                </div>
                <ul class="artBox_rifls">
                    <?php
                        $tmp='';
                        foreach ($info_zhaokao as $k => $v){
                            if($k<2){
                                $tmp.='<li><cite class="backred">'.($k+1).'</cite><a href="'.$v['url'].'">'.$v['title'].'</a></li>';
                            }else{
                                $tmp.='<li><cite>'.($k+1).'</cite><a href="'.$v['url'].'">'.$v['title'].'</a></li>';
                            }
                        }
                        echo $tmp;
                    ?>
                </ul>
                <ul class="artBox_rifls hide">
                    <?php
                    $tmp='';
                    foreach ($info_beikao as $k => $v){
                        if($k<2){
                            $tmp.='<li><cite class="backred">'.($k+1).'</cite><a href="'.$v['url'].'">'.$v['title'].'</a></li>';
                        }else{
                            $tmp.='<li><cite>'.($k+1).'</cite><a href="'.$v['url'].'">'.$v['title'].'</a></li>';
                        }
                    }
                    echo $tmp;
                    ?>
                </ul>
                <ul class="artBox_rifls hide">
                    <?php
                    $tmp='';
                    foreach ($info_shiti as $k => $v){
                        if($k<2){
                            $tmp.='<li><cite class="backred">'.($k+1).'</cite><a href="'.$v['url'].'">'.$v['title'].'</a></li>';
                        }else{
                            $tmp.='<li><cite>'.($k+1).'</cite><a href="'.$v['url'].'">'.$v['title'].'</a></li>';
                        }
                    }
                    echo $tmp;
                    ?>
                </ul>
            </div>
            <?php $suipian7 = file_get_contents("../../templets/default/".$suipian7);echo iconv('GBK','UTF-8',$suipian7);?>

            <?php $suipian8 = file_get_contents("../../templets/default/".$suipian8);echo iconv('GBK','UTF-8',$suipian8);?>

            <div class="artBox_rtk">
                <h3><a href="http://www.huatu.com/a/ztk/">更多</a><span>在线题库</span></h3>
                <div class="artBox_rtknum">
                </div>
                <ul class="artBox_rtkls">
                    <li><a href="http://bj.huatu.com/2017/1217/820509.html">2018年北京公务员考试行测答案（常识判断）</a></li>
                    <li><a href="http://bj.huatu.com/2017/1217/820508.html">2018年北京公务员考试行测答案（言语理解）</a></li>
                    <li><a href="http://bj.huatu.com/2017/1217/820507.html">2018年北京公务员考试行测答案（数量资料）</a></li>
                    <li><a href="http://bj.huatu.com/2017/1217/820505.html">2018年北京公务员考试行测答案（判断推理）</a></li>
                    <li><a href="http://bj.huatu.com/2017/1217/820501.html">2018年北京公务员考试行测答案解析（汇总）</a></li>

                </ul>
            </div>
            <div class="artBox_rask">
                <div class="title"><a href="http://ask.huatu.com/">我要问答</a><span>在线问答</span></div>
                <?php $suipian9 = file_get_contents("../../templets/default/".$suipian9);echo iconv('GBK','UTF-8',$suipian9);?>
            </div>
        </div>
    </div>
</div>

<!-- 底部 -->
<?php $suipian10 = file_get_contents("../../templets/default/".$suipian10);echo iconv('GBK','UTF-8',$suipian10);?>
<!-- 尾部 -->

</body>
</html>