getCategory(1);
if ($_type == 'parent') {
$_parent = $_category->getParents($_catlist, $_typeid);
$_typeid = $_parent[0]['id'];
}
$type = $_category->getOneCategory($_typeid);
$type['url'] = $_category->getCategoryUrl($type);
$type = update_str_dq($type, config('sys.sys_area'));
?>
您当前所在位置：
-
0 || substr($_cid, 0, 1) == '$') {
$_category = new app\index\model\CategoryModel();
if (strpos($_cid, ',')) {
$_cidarr = explode(',', $_cid);
$_ids = [];
foreach ($_cidarr as $_k => $_v) {
$_ids = array_merge($_ids, $_category->getChildsId($_category->getCategory(), $_v, true));
}
}else{
$_ids = $_category->getChildsId($_category->getCategory(), $_cid, true);
}
$_where = array('create_time' => array('LT', time()), 'cid'=> array('IN', $_ids));
}else {
$_where = array('create_time' => array('LT', time()));
}
if ($_keyword != -1) {
$_where['title'] = array('LIKE','%'.$_keyword.'%');
}
if ($_flag) {
$_where['istop'] = $_flag;
}
if ($_time) {
$_where['update_time'] = ['GT', time()-$_time];
}
if ($_top) {
$_where['top'] = $_top;
}
if ($_image != -1) {
$_where['pic'] = $_image ? ['NEQ', ''] : ['EQ', ''];
}
if ($_tag != -1) {
$_jgf = ',';
$_jgf = strpos($_tag, '，') ? '，' : $_jgf;
$_taglist = explode($_jgf,$_tag);
if (count($_taglist) > 1) {
$_tagarr = array();
foreach ($_taglist as $_k => $_v) {
$_tagarr[] = ['LIKE','%'.$_v.'%'];
}
$_tagarr[] = 'or';
$_where['tag'] = $_tagarr;
}else{
$_where['tag'] = ['LIKE','%'.$_tag.'%'];
}
}
$_where['create_time'] = ['LT', time()];
//地区独立内容
if ($_areaid) {
$_arealist = explode(',', $_areaid);
$_areawhere = [];
foreach ($_arealist as $key => $value) {
if ($value) {
$_areawhere[] = ['LIKE','%,'.$value.',%'];
}
}
if (count($_areawhere) > 1) {
$_areawhere[] = 'or';
$_where['area'] = $_areawhere;
}else{
$_where['area'] = $_areawhere[0];
}
}else{
$_area = session('sys_areainfo');
if ($_area) {
$_where['area'] = [['exp',' is NULL'],['eq',''],['eq',',,'],['LIKE','%,'.$_area['id'].',%'], 'or'];
}else{
$_where['area'] = [['exp',' is NULL'],['eq',''],['eq',',,'],['LIKE','%,88888888,%'], 'or'];
}
}
$_wheresql = '';
$_pageurlarr = [];
if ($_sql != -1) {
//拼接SQL语句
$_db = db('diyfield');
$_sqlstrlist = explode(" ", $_sql);
$_sqlstr = ' ';
if ($_sqlstrlist) {
foreach ($_sqlstrlist as $key1 => $value1) {
if (is_numeric($value1)) {
$_fieldname = $_db->where(['id'=>$value1])->value('field');
if ($_GET[$_fieldname] != '不限' && $_GET[$_fieldname] != '') {
$_filelist = explode(',', $_GET[$_fieldname]);
$_instr = "";
foreach ($_filelist as $key2 => $value2) {
if ($value2) {
$_instr = $_instr ? $_instr." OR ($_fieldname LIKE '%".$value2."%')" : "($_fieldname LIKE '%".$value2."%')";
}
}
$_sqlstr = $_sqlstr."($_instr) ";
}else{
$_sqlstr = $_sqlstr."( 1 = 1 ) ";
}
$_pageurlarr[$_fieldname] = $_GET[$_fieldname];
}else{
if ($value1 == 'or') {
$_sqlstr = $_sqlstr."or ";
}
if ($value1 == 'and' ) {
$_sqlstr = $_sqlstr."and ";
}
}
}
}
$_wheresql = $_sqlstr;
}
//获取模型别名
$_tabname = "";
if ($_cid != -1 && !empty($_cid)) {
$_mid = db('category')->where(['id'=>$_cid])->value('mid');
$_tabname = db('diymodel')->where(['id'=>$_mid])->value('tabname');
}
$page = "";//分页
if ($_pagesize > 0) {
$_pagearr = [];
switch (config('sys.url_model')) {
case '1'://动态
$param['s'] = request()->pathinfo();
$param = array_merge($param, request()->param());
$_pagearr = ['query' => $param];
break;
case '3'://伪静态
$_pagearr = ['query' => []];
break;
}
$_pagearr['var_link_rows'] = 7;
//存在cid情况
if ($_tabname) {
$_infolist = db('content')
->alias('con')
->join(config('database.prefix').'diy_'.$_tabname.' diy','con.vid = diy.conid')
->where($_where)
->where($_wheresql)
->order("create_time desc")
->paginate($_pagesize, false, $_pagearr);
}else{
$_infolist = db('content')
->where($_where)
->order("create_time desc")
->paginate($_pagesize, false, $_pagearr);
}
$page = $_infolist->render();
$page = preg_replace("#/([\d]*)page/#", '/page/', $page);
//搜索组合参数
if (config('sys.url_model') == 3 && $_keyword && !isset($_GET['key']) && input('key')) {
$page = str_replace("/page/", '/key/'.input('key').'/page/', $page);
}
if (config('sys.url_model') == 3 && $_area) {
if ($_area['isurl'] == 0) {
//$_ctitle = input('ctitle', '', 'trim');
//$page = str_replace($_ctitle."/", $_area['etitle'].'_'.$_ctitle."/", $page);
}
}
if (!$_pagecss) {
$page = preg_replace('#
getCategory(1);
if ($_type == 'parent') {
$_parent = $_category->getParents($_catlist, $_typeid);
$_typeid = $_parent[0]['id'];
}
$type = $_category->getOneCategory($_typeid);
$type['url'] = $_category->getCategoryUrl($type);
$type = update_str_dq($type, config('sys.sys_area'));
?>
-
getCategory(1);
if (1 == 0) {
$_catlist = $_category->clearLink($_catlist);//去除外部链接的栏目
}
//type为parent
if ($_type == 'parent') {
$_parent = $_category->getParents($_catlist, $_cid);
$_catlist = $_category->unlimitedForLayer($_catlist, 'child', $_parent[0]['id']);
}else{
//type为top,忽略cid
if($_cid == 0 || $_type == 'top') {
$_catlist = $_category->unlimitedForLayer($_catlist);
}else {
if ($_type == 'self') {
//同级分类
$_typeinfo = $_category->getSelf($_catlist, $_cid );
$_catlist = $_category->unlimitedForLayer($_catlist, 'child', $_typeinfo['pid']);
}else {
//son，子类列表
$_catlist = $_category->unlimitedForLayer($_catlist, 'child', $_cid);
}
}
}
$_limit_list = explode(',', $_limit);
foreach($_catlist as $autoindex => $catlist):
if(count($_limit_list) > 1){
if(($autoindex < $_limit_list[0]) || ($autoindex > $_limit_list[1])) continue;
} else{
if($autoindex >= $_limit_list[0]) break;
}
$catlist = update_str_dq($catlist, config('sys.sys_area'));
?>
- class="now_cur">
-
0 || substr($_cid, 0, 1) == '$') {
$_category = new app\index\model\CategoryModel();
if (strpos($_cid, ',')) {
$_cidarr = explode(',', $_cid);
$_ids = [];
foreach ($_cidarr as $_k => $_v) {
$_ids = array_merge($_ids, $_category->getChildsId($_category->getCategory(), $_v, true));
}
}else{
$_ids = $_category->getChildsId($_category->getCategory(), $_cid, true);
}
$_where = array('create_time' => array('LT', time()), 'cid'=> array('IN', $_ids));
}else {
$_where = array('create_time' => array('LT', time()));
}
if ($_keyword != -1) {
$_where['title'] = array('LIKE','%'.$_keyword.'%');
}
if ($_flag) {
$_where['istop'] = $_flag;
}
if ($_time) {
$_where['update_time'] = ['GT', time()-$_time];
}
if ($_top) {
$_where['top'] = $_top;
}
if ($_image != -1) {
$_where['pic'] = $_image ? ['NEQ', ''] : ['EQ', ''];
}
if ($_tag != -1) {
$_jgf = ',';
$_jgf = strpos($_tag, '，') ? '，' : $_jgf;
$_taglist = explode($_jgf,$_tag);
if (count($_taglist) > 1) {
$_tagarr = array();
foreach ($_taglist as $_k => $_v) {
$_tagarr[] = ['LIKE','%'.$_v.'%'];
}
$_tagarr[] = 'or';
$_where['tag'] = $_tagarr;
}else{
$_where['tag'] = ['LIKE','%'.$_tag.'%'];
}
}
$_where['create_time'] = ['LT', time()];
//地区独立内容
if ($_areaid) {
$_arealist = explode(',', $_areaid);
$_areawhere = [];
foreach ($_arealist as $key => $value) {
if ($value) {
$_areawhere[] = ['LIKE','%,'.$value.',%'];
}
}
if (count($_areawhere) > 1) {
$_areawhere[] = 'or';
$_where['area'] = $_areawhere;
}else{
$_where['area'] = $_areawhere[0];
}
}else{
$_area = session('sys_areainfo');
if ($_area) {
$_where['area'] = [['exp',' is NULL'],['eq',''],['eq',',,'],['LIKE','%,'.$_area['id'].',%'], 'or'];
}else{
$_where['area'] = [['exp',' is NULL'],['eq',''],['eq',',,'],['LIKE','%,88888888,%'], 'or'];
}
}
$_wheresql = '';
$_pageurlarr = [];
if ($_sql != -1) {
//拼接SQL语句
$_db = db('diyfield');
$_sqlstrlist = explode(" ", $_sql);
$_sqlstr = ' ';
if ($_sqlstrlist) {
foreach ($_sqlstrlist as $key1 => $value1) {
if (is_numeric($value1)) {
$_fieldname = $_db->where(['id'=>$value1])->value('field');
if ($_GET[$_fieldname] != '不限' && $_GET[$_fieldname] != '') {
$_filelist = explode(',', $_GET[$_fieldname]);
$_instr = "";
foreach ($_filelist as $key2 => $value2) {
if ($value2) {
$_instr = $_instr ? $_instr." OR ($_fieldname LIKE '%".$value2."%')" : "($_fieldname LIKE '%".$value2."%')";
}
}
$_sqlstr = $_sqlstr."($_instr) ";
}else{
$_sqlstr = $_sqlstr."( 1 = 1 ) ";
}
$_pageurlarr[$_fieldname] = $_GET[$_fieldname];
}else{
if ($value1 == 'or') {
$_sqlstr = $_sqlstr."or ";
}
if ($value1 == 'and' ) {
$_sqlstr = $_sqlstr."and ";
}
}
}
}
$_wheresql = $_sqlstr;
}
//获取模型别名
$_tabname = "";
if ($_cid != -1 && !empty($_cid)) {
$_mid = db('category')->where(['id'=>$_cid])->value('mid');
$_tabname = db('diymodel')->where(['id'=>$_mid])->value('tabname');
}
$page = "";//分页
if ($_pagesize > 0) {
$_pagearr = [];
switch (config('sys.url_model')) {
case '1'://动态
$param['s'] = request()->pathinfo();
$param = array_merge($param, request()->param());
$_pagearr = ['query' => $param];
break;
case '3'://伪静态
$_pagearr = ['query' => []];
break;
}
$_pagearr['var_link_rows'] = 7;
//存在cid情况
if ($_tabname) {
$_infolist = db('content')
->alias('con')
->join(config('database.prefix').'diy_'.$_tabname.' diy','con.vid = diy.conid')
->where($_where)
->where($_wheresql)
->order("create_time desc")
->paginate($_pagesize, false, $_pagearr);
}else{
$_infolist = db('content')
->where($_where)
->order("create_time desc")
->paginate($_pagesize, false, $_pagearr);
}
$page = $_infolist->render();
$page = preg_replace("#/([\d]*)page/#", '/page/', $page);
//搜索组合参数
if (config('sys.url_model') == 3 && $_keyword && !isset($_GET['key']) && input('key')) {
$page = str_replace("/page/", '/key/'.input('key').'/page/', $page);
}
if (config('sys.url_model') == 3 && $_area) {
if ($_area['isurl'] == 0) {
//$_ctitle = input('ctitle', '', 'trim');
//$page = str_replace($_ctitle."/", $_area['etitle'].'_'.$_ctitle."/", $page);
}
}
if (!$_pagecss) {
$page = preg_replace('#
-
0 || substr($_cid, 0, 1) == '$') {
$_category = new app\index\model\CategoryModel();
if (strpos($_cid, ',')) {
$_cidarr = explode(',', $_cid);
$_ids = [];
foreach ($_cidarr as $_k => $_v) {
$_ids = array_merge($_ids, $_category->getChildsId($_category->getCategory(), $_v, true));
}
}else{
$_ids = $_category->getChildsId($_category->getCategory(), $_cid, true);
}
$_where = array('create_time' => array('LT', time()), 'cid'=> array('IN', $_ids));
}else {
$_where = array('create_time' => array('LT', time()));
}
if ($_keyword != -1) {
$_where['title'] = array('LIKE','%'.$_keyword.'%');
}
if ($_flag) {
$_where['istop'] = $_flag;
}
if ($_time) {
$_where['update_time'] = ['GT', time()-$_time];
}
if ($_top) {
$_where['top'] = $_top;
}
if ($_image != -1) {
$_where['pic'] = $_image ? ['NEQ', ''] : ['EQ', ''];
}
if ($_tag != -1) {
$_jgf = ',';
$_jgf = strpos($_tag, '，') ? '，' : $_jgf;
$_taglist = explode($_jgf,$_tag);
if (count($_taglist) > 1) {
$_tagarr = array();
foreach ($_taglist as $_k => $_v) {
$_tagarr[] = ['LIKE','%'.$_v.'%'];
}
$_tagarr[] = 'or';
$_where['tag'] = $_tagarr;
}else{
$_where['tag'] = ['LIKE','%'.$_tag.'%'];
}
}
$_where['create_time'] = ['LT', time()];
//地区独立内容
if ($_areaid) {
$_arealist = explode(',', $_areaid);
$_areawhere = [];
foreach ($_arealist as $key => $value) {
if ($value) {
$_areawhere[] = ['LIKE','%,'.$value.',%'];
}
}
if (count($_areawhere) > 1) {
$_areawhere[] = 'or';
$_where['area'] = $_areawhere;
}else{
$_where['area'] = $_areawhere[0];
}
}else{
$_area = session('sys_areainfo');
if ($_area) {
$_where['area'] = [['exp',' is NULL'],['eq',''],['eq',',,'],['LIKE','%,'.$_area['id'].',%'], 'or'];
}else{
$_where['area'] = [['exp',' is NULL'],['eq',''],['eq',',,'],['LIKE','%,88888888,%'], 'or'];
}
}
$_wheresql = '';
$_pageurlarr = [];
if ($_sql != -1) {
//拼接SQL语句
$_db = db('diyfield');
$_sqlstrlist = explode(" ", $_sql);
$_sqlstr = ' ';
if ($_sqlstrlist) {
foreach ($_sqlstrlist as $key1 => $value1) {
if (is_numeric($value1)) {
$_fieldname = $_db->where(['id'=>$value1])->value('field');
if ($_GET[$_fieldname] != '不限' && $_GET[$_fieldname] != '') {
$_filelist = explode(',', $_GET[$_fieldname]);
$_instr = "";
foreach ($_filelist as $key2 => $value2) {
if ($value2) {
$_instr = $_instr ? $_instr." OR ($_fieldname LIKE '%".$value2."%')" : "($_fieldname LIKE '%".$value2."%')";
}
}
$_sqlstr = $_sqlstr."($_instr) ";
}else{
$_sqlstr = $_sqlstr."( 1 = 1 ) ";
}
$_pageurlarr[$_fieldname] = $_GET[$_fieldname];
}else{
if ($value1 == 'or') {
$_sqlstr = $_sqlstr."or ";
}
if ($value1 == 'and' ) {
$_sqlstr = $_sqlstr."and ";
}
}
}
}
$_wheresql = $_sqlstr;
}
//获取模型别名
$_tabname = "";
if ($_cid != -1 && !empty($_cid)) {
$_mid = db('category')->where(['id'=>$_cid])->value('mid');
$_tabname = db('diymodel')->where(['id'=>$_mid])->value('tabname');
}
$page = "";//分页
if ($_pagesize > 0) {
$_pagearr = [];
switch (config('sys.url_model')) {
case '1'://动态
$param['s'] = request()->pathinfo();
$param = array_merge($param, request()->param());
$_pagearr = ['query' => $param];
break;
case '3'://伪静态
$_pagearr = ['query' => []];
break;
}
$_pagearr['var_link_rows'] = 7;
//存在cid情况
if ($_tabname) {
$_infolist = db('content')
->alias('con')
->join(config('database.prefix').'diy_'.$_tabname.' diy','con.vid = diy.conid')
->where($_where)
->where($_wheresql)
->order("create_time desc")
->paginate($_pagesize, false, $_pagearr);
}else{
$_infolist = db('content')
->where($_where)
->order("create_time desc")
->paginate($_pagesize, false, $_pagearr);
}
$page = $_infolist->render();
$page = preg_replace("#/([\d]*)page/#", '/page/', $page);
//搜索组合参数
if (config('sys.url_model') == 3 && $_keyword && !isset($_GET['key']) && input('key')) {
$page = str_replace("/page/", '/key/'.input('key').'/page/', $page);
}
if (config('sys.url_model') == 3 && $_area) {
if ($_area['isurl'] == 0) {
//$_ctitle = input('ctitle', '', 'trim');
//$page = str_replace($_ctitle."/", $_area['etitle'].'_'.$_ctitle."/", $page);
}
}
if (!$_pagecss) {
$page = preg_replace('#
