mayi_cms/m/include/inc_category.php

<?php
//decode by qq784939922

CURSCRIPT != 'wap' && exit('FORBIDDEN');
$catid = isset($catid) ? intval($catid) : 0;
$areaid = isset($areaid) ? intval($areaid) : 0;
$page = isset($page) ? intval($page) : 1;
runcron();
$seo = $seo ? $seo : get_seoset();
$rewrite = $seo['seo_force_category'];
if ($Catid && $rewrite == 'rewrite_py') {
    $detail = explode('/', $Catid);
    $dir_typename = $detail[0];
    $cat_dir = array_flip(get_category_dir());
    $catid = $cat_dir[$dir_typename];
    if ($detail[1]) {
        $detailc = explode('-', $detail[1]);
        for ($i = 0; $i < count($detailc); $i++) {
            $_GET[$detailc[$i]] = ${$detailc}[$i] = str_replace(array('#@#', '#!#'), array('-', '/'), $detailc[++$i]);
        }
        extract($_GET);
    }
    $cat_dir = $Catid = $detail = $detailc = NULL;
} else {
    if ($CAtid && $rewrite == 'rewrite') {
        $detail = explode('-', $CAtid);
        $catid = $detail[1];
        if ($detail[2]) {
            for ($i = 2; $i < count($detail); $i++) {
                $_GET[$detail[$i]] = ${$detail}[$i] = str_replace(array('#@#', '#!#'), array('-', '/'), $detail[++$i]);
            }
            extract($_GET);
        }
        $CAtid = $detail = NULL;
    }
}
$cat_list = get_categories_tree($catid);
if (empty($catid)) {
    include mymps_tpl('category_all');
    exit;
}
if (!($cat = get_cat_info($catid))) {
    errormsg('您所指定的栏目不存在或者已被删除！');
}
$perpage = $mayimobile['mobiletopicperpage'] ? $mayimobile['mobiletopicperpage'] : 10;
$allow_identifier = allow_identifier();
$allow_identifier = $allow_identifier[$cat['modid']]['identifier'];
$allow_identifier = is_array($allow_identifier) ? $allow_identifier : array();
$allow_identifiers = $rewrite == 'rewrite_py' ? array_merge(array('areaid'), $allow_identifier) : array_merge(array('catid', 'areaid'), $allow_identifier);
$mymps_extra_model = mod_identifier();
$mymps_extra_model = $mymps_extra_model[$cat['modid']];
$mymps_extra_model = is_array($mymps_extra_model) ? $mymps_extra_model : array();
$parentcats = get_parent_cats('category', $catid);
$parentcats = is_array($parentcats) ? array_reverse($parentcats) : '';
$area_list = cat_list('area', 0, 0, false, 1);
$area_list = array_merge(array(array('areaid' => '0', 'areaname' => '不限')), $area_list);
$sq = $s = '';
if (1 < $cat['modid']) {
    $s = '';
    foreach ($_GET as $key => $val) {
        if (in_array($key, $allow_identifier) && !empty($key)) {
            $val = explode('~', $val);
            $val[0] = $val[0] ? intval($val[0]) : '';
            $val[1] = $val[1] ? intval($val[1]) : '';
            if ($val[1]) {
                $sq .= ' AND g.`' . $key . '` <= \'' . $val[1] . '\'  AND g.`' . $key . '` >= \'' . $val[0] . '\'';
            } else {
                if ($val[0] && 0 < $val[1]) {
                    $sq .= ' AND g.`' . $key . '` >= \'' . $val[0] . '\'';
                } else {
                    $sq .= ' AND g.`' . $key . '` = \'' . $val[0] . '\' ';
                }
            }
            $s = ' LEFT JOIN `' . $db_mymps . 'information_' . $cat[modid] . '` AS g ON a.id = g.id';
        }
    }
}
$cate_limit = 0 < $cat['parentid'] ? ' AND ' . get_children($catid) : ' AND a.gid = \'' . $catid . '\'';
$city_limit = empty($city['cityid']) ? '' : ' AND a.cityid = \'' . $city['cityid'] . '\'';
$city_limit .= empty($areaid) ? '' : ' AND a.areaid = \'' . $areaid . '\'';
$orderby = $cat['parentid'] == 0 ? ' ORDER BY a.upgrade_type DESC,a.begintime DESC' : ' ORDER BY a.upgrade_type_list DESC,a.begintime DESC';
$param = setparams($allow_identifiers);
$rows_num = $cat['totalnum'] = $db->getOne('SELECT COUNT(a.id) FROM `' . $db_mymps . 'information` AS a ' . $s . ' WHERE a.info_level > 0 ' . $sq . $cate_limit . $city_limit);
$totalpage = ceil($rows_num / $perpage);
$num = intval($page - 1) * $perpage;
$idin = get_page_idin('id', 'SELECT a.id FROM `' . $db_mymps . 'information` AS a ' . $s . ' WHERE (a.info_level = 1 OR a.info_level = 2) ' . $sq . $cate_limit . $city_limit . $orderby, $perpage);
$idin2 = $idin ? ' AND a.infoid IN (' . $idin . ') ' : '';
$idin = $idin ? ' AND a.id IN (' . $idin . ') ' : '';
$sql = 'SELECT a.*,b.areaname FROM ' . $db_mymps . 'information AS a  LEFT JOIN `' . $db_mymps . 'area` AS b ON a.areaid = b.areaid WHERE 1 ' . $idin . ' ' . $orderby;
$infolist = $idin ? $db->getAll($sql) : array();
foreach ($infolist as $k => $row) {
    $arr['id'] = $row['id'];
    $arr['face'] = $row['face'];
    $arr['face'] = @strstr($arr['face'], 'http') ? $arr['face'] : $mymps_global['SiteUrl'] . $arr['face'];
    $arr['title'] = $row['title'];
    $arr['titlej'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['title']) : $arr['title'];
    $arr['hit'] = $row['hit'];
    $arr['uri_m'] = mRewrite('info', array('id' => $row[id], 'dir_typename' => $row['dir_typename']));
    $arr['img_path'] = $row['img_path'];
    $arr['ifred'] = $row['ifred'];
    $arr['ifbold'] = $row['ifbold'];
    $arr['hit'] = $row['hit'];
    $arr['zan'] = intval($row['zan']);
    $arr['certify'] = $row['certify'];
    $arr['catname'] = $row['catname'];
    $arr['catnamej'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['catname']) : $arr['catname'];
    $arr['areaname'] = $row['areaname'];
    $arr['areanamej'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['areaname']) : $arr['areaname'];
    $arr['tel'] = empty($cat['usecoin']) ? 'tel:' . $row['tel'] : $arr['uri_m'];
    $arr['img_count'] = $row['img_count'];
    $arr['upgrade_type'] = !$cat['parentid'] ? $row['upgrade_type'] : $row['upgrade_type_list'];
    $arr['userid'] = $row['userid'] ? $row['userid'] : $row['contact_who'];
    $arr['useridj'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['userid']) : $arr['userid'];
    $arr['content'] = $row['content'];
    $arr['contentj'] = cutstr(clear_html($row['content']), 50);
    $arr['contentj'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['contentj']) : $arr['contentj'];
    $arr['begintime'] = get_format_time($row['begintime']);
    $arr['endtime'] = $row['endtime'] ? $row['endtime'] : $timestamp;
    $info_list[$row['id']] = $arr;
    $ids .= $row['id'] . ',';
    if (0 < $row['upgrade_time'] && $row['upgrade_time'] < $timestamp) {
        $db->query('UPDATE `' . $db_mymps . 'information` SET upgrade_type = \'1\',upgrade_time = \'0\' WHERE id =\'' . $row['id'] . '\'');
    }
    if (0 < $row['upgrade_time_list'] && $row['upgrade_time_list'] < $timestamp) {
        $db->query('UPDATE `' . $db_mymps . 'information` SET upgrade_type_list = \'1\',upgrade_time_list = \'0\' WHERE id =\'' . $row['id'] . '\'');
    }
}
if ($idin2) {
    $iquery = $db->query('SELECT a.infoid,a.prepath FROM `' . $db_mymps . 'info_img` AS a WHERE 1 ' . $idin2);
    while ($r = $db->fetchRow($iquery)) {
            $info_list[$r['infoid']]['img'][] = $r['prepath'];
    }
}
$i = NULL;
if (1 < $cat['modid'] && $idin) {
    $des = get_info_option_array();
    $extra = $db->getAll('SELECT a.* FROM `' . $db_mymps . 'information_' . $cat[modid] . '` AS a WHERE 1 ' . $idin);
    foreach ($extra as $k => $v) {
        unset($v['iid']);
        unset($v['content']);
        foreach ($v as $u => $w) {
            $g = get_info_option_titval($des[$u], $w);
            if ($u != 'id' && !is_numeric($u)) {
                $info_list[$v['id']]['extra'][$u] = $g['value'];
                $info_list[$v['id']]['extraj'][$u] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $g['value']) : $g['value'];
                $info_list[$v['id']][$u] = $g['value'];
            }
        }
    }
}
if ($mayi) {
    $info_list = 5.4 <= PHP_VERSION ? json_encode($info_list, JSON_UNESCAPED_SLASHES) : str_replace('\\/', '/', json_encode($info_list));
    echo $info_list;
    exit;
}
switch ($rewrite) {
    case 'rewrite':
        foreach ($mymps_extra_model as $key => $val) {
            if (is_array($val['list'])) {
                foreach ($val['list'] as $k => $v) {
                    $mymps_extra_model[$key]['list'][$k]['uri'] = 'category';
                    $mymps_extra_model[$key]['list'][$k]['uri_a'] = 'index.php?mod=category&areaid=' . $areaid;
                    foreach ($allow_identifiers as $keys) {
                        if ($v['identifier'] == $keys) {
                            $mymps_extra_model[$key]['list'][$k]['uri'] .= $v['id'] ? '-' . $keys . '-' . $v['id'] : '';
                            $mymps_extra_model[$key]['list'][$k]['uri_a'] .= $v['id'] ? '&' . $keys . '=' . $v['id'] : '';
                        } else {
                            $mymps_extra_model[$key]['list'][$k]['uri'] .= ${$keys} ? '-' . $keys . '-' . ${$keys} : '';
                            $mymps_extra_model[$key]['list'][$k]['uri_a'] .= ${$keys} ? '&' . $keys . '=' . ${$keys} : '';
                        }
                    }
                    $mymps_extra_model[$key]['list'][$k]['uri'] .= '.html';
                    if ($v['id'] == ${$v}['identifier']) {
                        $mymps_extra_model[$key]['list'][$k]['select'] .= 1;
                        $page_title_extra .= $v[name] != '不限' ? $v[name] : '';
                    } else {
                        $mymps_extra_model[$key]['list'][$k]['select'] .= 0;
                    }
                }
            }
        }
        foreach ($area_list as $key => $val) {
            $area_list[$key]['uri'] = '/category';
            foreach ($allow_identifiers as $keys) {
                if ($keys == 'areaid') {
                    $area_list[$key]['uri'] .= $val['areaid'] ? '-' . $keys . '-' . $val[areaid] : '';
                } else {
                    $area_list[$key]['uri'] .= ${$keys} ? '-' . $keys . '-' . ${$keys} : '';
                }
            }
            $area_list[$key]['uri'] .= '.html';
            $area_list[$key]['select'] = $val['areaid'] == $areaid ? 1 : 0;
        }
        break;
    case 'rewrite_py':
        foreach ($mymps_extra_model as $key => $val) {
            if (is_array($val['list'])) {
                foreach ($val['list'] as $k => $v) {
                    $mymps_extra_model[$key]['list'][$k]['uri'] = '/' . $dir_typename . '/';
                    $mymps_extra_model[$key]['list'][$k]['uri_a'] = 'index.php?mod=category&areaid=' . $areaid;
                    foreach ($allow_identifiers as $keys) {
                        if ($v['identifier'] == $keys) {
                            $mymps_extra_model[$key]['list'][$k]['uri'] .= $v['id'] ? $keys . '-' . $v['id'] . '-' : '';
                            $mymps_extra_model[$key]['list'][$k]['uri_a'] .= $v['id'] ? '&' . $keys . '=' . $v['id'] : '';
                        } else {
                            $mymps_extra_model[$key]['list'][$k]['uri'] .= ${$keys} ? $keys . '-' . ${$keys} . '-' : '';
                            $mymps_extra_model[$key]['list'][$k]['uri_a'] .= ${$keys} ? '&' . $keys . '=' . ${$keys} : '';
                        }
                    }
                    $mymps_extra_model[$key]['list'][$k]['uri'] = substr($mymps_extra_model[$key]['list'][$k]['uri'], 0, -1);
                    $mymps_extra_model[$key]['list'][$k]['uri'] .= '/';
                    if ($v['id'] == ${$v}['identifier']) {
                        $mymps_extra_model[$key]['list'][$k]['select'] .= 1;
                        $page_title_extra .= $v['name'] != '不限' ? $v['name'] : '';
                    } else {
                        $mymps_extra_model[$key]['list'][$k]['select'] .= 0;
                    }
                }
            }
        }
        foreach ($area_list as $key => $val) {
            $area_list[$key]['uri'] = '/' . $dir_typename . '/';
            foreach ($allow_identifiers as $keys) {
                if ($keys == 'areaid') {
                    $area_list[$key]['uri'] .= $val['areaid'] ? $keys . '-' . $val['areaid'] . '-' : '';
                } else {
                    $area_list[$key]['uri'] .= ${$keys} ? $keys . '-' . ${$keys} . '-' : '';
                }
            }
            $area_list[$key]['uri'] = substr($area_list[$key]['uri'], 0, -1);
            $area_list[$key]['uri'] .= '/';
            $area_list[$key]['select'] = $val['areaid'] == $areaid ? 1 : 0;
        }
        break;
    default:
        foreach ($mymps_extra_model as $key => $val) {
            if (is_array($val['list'])) {
                foreach ($val['list'] as $k => $v) {
//                  $mymps_extra_model[$key]['list'][$k]['uri'] = 'category.php?';
                    $mymps_extra_model[$key]['list'][$k]['uri'] = 'index.php?mod=category&';
                    $mymps_extra_model[$key]['list'][$k]['uri_a'] = 'index.php?mod=category&areaid=' . $areaid;
                    foreach ($allow_identifiers as $keys) {
                        if ($v['identifier'] == $keys) {
                            $mymps_extra_model[$key]['list'][$k]['uri'] .= $v['id'] ? $keys . '=' . $v[id] . '&' : '';
                            $mymps_extra_model[$key]['list'][$k]['uri_a'] .= $v['id'] ? '&' . $keys . '=' . $v[id] : '';
                        } else {
                            $mymps_extra_model[$key]['list'][$k]['uri'] .= ${$keys} ? $keys . '=' . ${$keys} . '&' : '';
                            $mymps_extra_model[$key]['list'][$k]['uri_a'] .= ${$keys} ? '&' . $keys . '=' . ${$keys} : '';
                        }
                    }
                    $mymps_extra_model[$key]['list'][$k]['uri'] = substr($mymps_extra_model[$key]['list'][$k]['uri'], 0, -1);
                    if ($v[id] == ${$v}[identifier]) {
                        $mymps_extra_model[$key]['list'][$k]['select'] .= 1;
                        $page_title_extra .= $v[name] != '不限' ? $v[name] : '';
                    } else {
                        $mymps_extra_model[$key]['list'][$k]['select'] .= 0;
                    }
                }
            }
        }
        foreach ($area_list as $key => $val) {
//          $area_list[$key]['uri'] = '/index.php?mod=category&';
            $area_list[$key]['uri'] = 'index.php?mod=category&';
            foreach ($allow_identifiers as $keys) {
                if ($keys == 'areaid') {
                    $area_list[$key]['uri'] .= $val['areaid'] ? $keys . '=' . $val[areaid] . '&' : '';
                } else {
                    $area_list[$key]['uri'] .= ${$keys} ? $keys . '=' . ${$keys} . '&' : '';
                }
            }
            $area_list[$key]['uri'] = substr($area_list[$key]['uri'], 0, -1);
            $area_list[$key]['select'] = $val['areaid'] == $areaid ? 1 : 0;
        }
        break;
}
$pdetail = $mymps_global['SiteCity'] . $page_title_extra . ($cat['title'] ? $cat['title'] : $cat['catname']);
$pdetail .= 1 < $page ? '-第' . $page . '页' : '';
$pdetail .= '-' . $mymps_global['SiteName'];
$loc = get_location_m('category', $catid, '', '', $pdetail);
$page_title = $loc['page_title'];
$cat['keywords'] = $cat['keywords'] ? $cat['keywords'] : $cat['catname'] . '信息';
$cat['description'] = $cat['description'] ? $cat['description'] : $mymps_global['SiteCity'] . $cat['catname'] . '频道为您提供' . $mymps_global['SiteCity'] . $cat['catname'] . '信息，在此有大量' . $mymps_global['SiteCity'] . $cat['catname'] . '信息供您选择，您可以免费查看和发布' . $mymps_global['SiteCity'] . $cat['catname'] . '信息。';
include mymps_tpl('category_list');