dforeach;
$_cid = 47;
$_limit = "5,1";
$_keyword = -1;
$_flag = '';
$_time = '';
$_areaid = '';//指定地区ID
$_top = '';
$_image = '-1';
$_pagesize = 0;
$_pagecss = 1;
$_tag = -1;
$_sql = "-1";
if($_cid == -1) $_cid = input('cid');
if ($_cid > 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 = ['create_time' => ['LT', time()]];
$_where[] = function ($_q) use($_ids){
$_q->where(['cid' => ['IN', $_ids]])->whereor("CONCAT(',',addcid,',') REGEXP CONCAT(',(',REPLACE('".implode(',', $_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] != '' && $_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("id DESC")
->paginate($_pagesize, false, $_pagearr);
}else{
$_infolist = db('content')
->where($_where)
->order("id 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('#
#', "", $page);
}
}else {
//存在cid情况
if ($_tabname) {
$_infolist = db('content')
->alias('con')
->join(config('database.prefix').'diy_'.$_tabname.' diy','con.vid = diy.conid')
->where($_where)
->where($_wheresql)
->order("id DESC")
->limit($_limit)
->select();
}else{
$_infolist = db('content')
->where($_where)
->order("id DESC")
->limit($_limit)
->select();
}
}
//组合筛选修改分页URL
if ($_pageurlarr) {
$_ljstr = config('sys.url_model') == '1' ? "&" : "?";
$page = preg_replace('/href=[\'|\"](\S+)[\'|\"]/i', 'href=$1'.$_ljstr.build_query($_pageurlarr), $page);
}
$_content = new app\index\model\ContentModel();
foreach ($_infolist as $k => $list):
$list = $_content->getContentByCon($list);
$list['alltitle'] = $list['title'];
if(0) $list['title'] = str2sub($list['title'], 0, 0);
$list = $_content->getContentArea($list);
$list = update_str_dq($list, session('sys_areainfo'));
?>
广东省东莞市万江区石美社区普洱茶回收中心
dforeach;
$_cid = 47;
$_limit = "5,1";
$_keyword = -1;
$_flag = '';
$_time = '';
$_areaid = '';//指定地区ID
$_top = '';
$_image = '-1';
$_pagesize = 0;
$_pagecss = 1;
$_tag = -1;
$_sql = "-1";
if($_cid == -1) $_cid = input('cid');
if ($_cid > 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 = ['create_time' => ['LT', time()]];
$_where[] = function ($_q) use($_ids){
$_q->where(['cid' => ['IN', $_ids]])->whereor("CONCAT(',',addcid,',') REGEXP CONCAT(',(',REPLACE('".implode(',', $_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] != '' && $_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("id DESC")
->paginate($_pagesize, false, $_pagearr);
}else{
$_infolist = db('content')
->where($_where)
->order("id 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('##', "", $page);
}
}else {
//存在cid情况
if ($_tabname) {
$_infolist = db('content')
->alias('con')
->join(config('database.prefix').'diy_'.$_tabname.' diy','con.vid = diy.conid')
->where($_where)
->where($_wheresql)
->order("id DESC")
->limit($_limit)
->select();
}else{
$_infolist = db('content')
->where($_where)
->order("id DESC")
->limit($_limit)
->select();
}
}
//组合筛选修改分页URL
if ($_pageurlarr) {
$_ljstr = config('sys.url_model') == '1' ? "&" : "?";
$page = preg_replace('/href=[\'|\"](\S+)[\'|\"]/i', 'href=$1'.$_ljstr.build_query($_pageurlarr), $page);
}
$_content = new app\index\model\ContentModel();
foreach ($_infolist as $k => $list):
$list = $_content->getContentByCon($list);
$list['alltitle'] = $list['title'];
if(0) $list['title'] = str2sub($list['title'], 0, 0);
$list = $_content->getContentArea($list);
$list = update_str_dq($list, session('sys_areainfo'));
?>
广东省东莞市万江区石美社区普洱茶回收中心
dforeach;
$_cid = 47;
$_limit = "5,1";
$_keyword = -1;
$_flag = '';
$_time = '';
$_areaid = '';//指定地区ID
$_top = '';
$_image = '-1';
$_pagesize = 0;
$_pagecss = 1;
$_tag = -1;
$_sql = "-1";
if($_cid == -1) $_cid = input('cid');
if ($_cid > 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 = ['create_time' => ['LT', time()]];
$_where[] = function ($_q) use($_ids){
$_q->where(['cid' => ['IN', $_ids]])->whereor("CONCAT(',',addcid,',') REGEXP CONCAT(',(',REPLACE('".implode(',', $_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] != '' && $_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("id DESC")
->paginate($_pagesize, false, $_pagearr);
}else{
$_infolist = db('content')
->where($_where)
->order("id 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('##', "", $page);
}
}else {
//存在cid情况
if ($_tabname) {
$_infolist = db('content')
->alias('con')
->join(config('database.prefix').'diy_'.$_tabname.' diy','con.vid = diy.conid')
->where($_where)
->where($_wheresql)
->order("id DESC")
->limit($_limit)
->select();
}else{
$_infolist = db('content')
->where($_where)
->order("id DESC")
->limit($_limit)
->select();
}
}
//组合筛选修改分页URL
if ($_pageurlarr) {
$_ljstr = config('sys.url_model') == '1' ? "&" : "?";
$page = preg_replace('/href=[\'|\"](\S+)[\'|\"]/i', 'href=$1'.$_ljstr.build_query($_pageurlarr), $page);
}
$_content = new app\index\model\ContentModel();
foreach ($_infolist as $k => $list):
$list = $_content->getContentByCon($list);
$list['alltitle'] = $list['title'];
if(0) $list['title'] = str2sub($list['title'], 0, 0);
$list = $_content->getContentArea($list);
$list = update_str_dq($list, session('sys_areainfo'));
?>
广东省东莞市万江区石美社区普洱茶回收中心
dforeach;
$_cid = 47;
$_limit = "5,1";
$_keyword = -1;
$_flag = '';
$_time = '';
$_areaid = '';//指定地区ID
$_top = '';
$_image = '-1';
$_pagesize = 0;
$_pagecss = 1;
$_tag = -1;
$_sql = "-1";
if($_cid == -1) $_cid = input('cid');
if ($_cid > 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 = ['create_time' => ['LT', time()]];
$_where[] = function ($_q) use($_ids){
$_q->where(['cid' => ['IN', $_ids]])->whereor("CONCAT(',',addcid,',') REGEXP CONCAT(',(',REPLACE('".implode(',', $_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] != '' && $_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("id DESC")
->paginate($_pagesize, false, $_pagearr);
}else{
$_infolist = db('content')
->where($_where)
->order("id 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('##', "", $page);
}
}else {
//存在cid情况
if ($_tabname) {
$_infolist = db('content')
->alias('con')
->join(config('database.prefix').'diy_'.$_tabname.' diy','con.vid = diy.conid')
->where($_where)
->where($_wheresql)
->order("id DESC")
->limit($_limit)
->select();
}else{
$_infolist = db('content')
->where($_where)
->order("id DESC")
->limit($_limit)
->select();
}
}
//组合筛选修改分页URL
if ($_pageurlarr) {
$_ljstr = config('sys.url_model') == '1' ? "&" : "?";
$page = preg_replace('/href=[\'|\"](\S+)[\'|\"]/i', 'href=$1'.$_ljstr.build_query($_pageurlarr), $page);
}
$_content = new app\index\model\ContentModel();
foreach ($_infolist as $k => $list):
$list = $_content->getContentByCon($list);
$list['alltitle'] = $list['title'];
if(0) $list['title'] = str2sub($list['title'], 0, 0);
$list = $_content->getContentArea($list);
$list = update_str_dq($list, session('sys_areainfo'));
?>
广东省东莞市万江区石美社区普洱茶回收中心
dforeach;
$_cid = 47;
$_limit = "5,1";
$_keyword = -1;
$_flag = '';
$_time = '';
$_areaid = '';//指定地区ID
$_top = '';
$_image = '-1';
$_pagesize = 0;
$_pagecss = 1;
$_tag = -1;
$_sql = "-1";
if($_cid == -1) $_cid = input('cid');
if ($_cid > 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 = ['create_time' => ['LT', time()]];
$_where[] = function ($_q) use($_ids){
$_q->where(['cid' => ['IN', $_ids]])->whereor("CONCAT(',',addcid,',') REGEXP CONCAT(',(',REPLACE('".implode(',', $_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] != '' && $_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("id DESC")
->paginate($_pagesize, false, $_pagearr);
}else{
$_infolist = db('content')
->where($_where)
->order("id 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('##', "", $page);
}
}else {
//存在cid情况
if ($_tabname) {
$_infolist = db('content')
->alias('con')
->join(config('database.prefix').'diy_'.$_tabname.' diy','con.vid = diy.conid')
->where($_where)
->where($_wheresql)
->order("id DESC")
->limit($_limit)
->select();
}else{
$_infolist = db('content')
->where($_where)
->order("id DESC")
->limit($_limit)
->select();
}
}
//组合筛选修改分页URL
if ($_pageurlarr) {
$_ljstr = config('sys.url_model') == '1' ? "&" : "?";
$page = preg_replace('/href=[\'|\"](\S+)[\'|\"]/i', 'href=$1'.$_ljstr.build_query($_pageurlarr), $page);
}
$_content = new app\index\model\ContentModel();
foreach ($_infolist as $k => $list):
$list = $_content->getContentByCon($list);
$list['alltitle'] = $list['title'];
if(0) $list['title'] = str2sub($list['title'], 0, 0);
$list = $_content->getContentArea($list);
$list = update_str_dq($list, session('sys_areainfo'));
?>
广东省东莞市万江区石美社区普洱茶回收中心
