zc100/template/mobile-bak2_1/components/list/style9/list.htm

<?php
//栏目id
$tyid = ['0','126','825','826','','126'];

//只调用省级 城市为空
if((int)$provid === 0 && (int)$catid === 0){
    //所有省份的数据
    //$where = "typeid=".$tyid[$type]." and province_id > 0 and city_id='0' and is_del=0";
    $where = "typeid=".$tyid[$type]." and is_del=0";
}else if((int)$provid > 0 && (int)$catid === 0){
    //只选择省 不选择职称
    $where = "typeid=".$tyid[$type]." and province_id='$provid' and city_id='0' and is_del=0";
}else{
    //职称 > 0 那么理论上省=0或>0  但这里省必定>0
    $where = "typeid=".$tyid[$type]." and province_id='$provid' and stypeid='$catid' and city_id='0' and is_del=0";
}

if($tagid > 0){
    //加入筛选
    $where = $where.' and product_tag_id='.$tagid;
}


if(!empty($wareaname) && $wareaname == 'shandong'){
    //查询id
    $where = $where.' and area_tag_id=10000';
}

?>
{eyou:php}
//计算limit属性
$pagesize = 20;
if(!empty($route_param['pa'])){
$curpage = $route_param['pa'];
$start_li = $pagesize*($curpage-1); //开始位置
$end_li = $pagesize*$curpage;
$limit_cat_value = $start_li.','.$pagesize;
}else{
$curpage = 1;
$limit_cat_value = '0,'.$pagesize;
}
{/eyou:php}
{eyou:assign name='limit_cat' value="$limit_cat_value" /}
<?php
//$sql = "select GROUP_CONCAT(aid SEPARATOR ',') AS ids from ey_archives where $where order by update_time desc limit $limit_cat";
$sql = "select aid from ey_archives where $where order by update_time desc limit $limit_cat";
//echo $sql;die;
$ids = '';
?>
{eyou:sql sql="$sql" cachetime='3600' empty='没有数据' id="res"}
<?php
//var_dump($provid);
//var_dump($res);
$ids = $res['aid'].','.$ids;
?>
{/eyou:sql}
<?php
$ids = preg_replace("/.$/", "", $ids);
?>
<!--开始查询-->
{eyou:empty name='$ids' /}
----------------------(暂无相关文档)-----------------------
{eyou:else /}
{eyou:artlist idlist="$ids" titlelen='30' infolen='160' limit="0,20" orderby='update_time desc' addfields='down'}
<li>
    <?php
    $extension = substr($field['down'], strrpos($field['down'], '.') + 1);
    ?>
    <div style=""></div>
    <span>.{$extension}</span>
    <img src="https://oss.zc10000.com/static/img/{$extension}.svg" />
    <a href="{:get_tid_url_2($field['arcurl'],$field['typeid'],$field['stypeid'],0,'',0,$field['province_id'])}" class="k">{$field.title}</a>
    <!--<p>
        <img src="https://oss.zc10000.com/static/images/031.SVG">
        <font class="sp-1">评审时间</font>
        <font class="sp-2">{$field.handle_time}</font>
    </p>-->

    <p>
        <font>阅读量: {$field.click}</font>
        <font>收藏量: {$field.collection}</font>
        <font>点赞量: {$field.likecount}</font>
        <font>下载量: {$field.downcount}</font>
    </p>
    <a href="{:get_tid_url_2($field['arcurl'],$field['typeid'],$field['stypeid'],0,'',0,$field['province_id'])}">
        <button>
            前往下载
        </button></a>
</li>
{/eyou:artlist}
{/eyou:empty}