欢迎光临桂林POS机办理中心官网!
专业POS机办理平台正规一清机 个人免费申请 全国包邮
全国咨询热线:15383350067
产品展示
热销产品
    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')); ?>
  • <?php echo $list['title']; ?>
联系我们

地址: where("title='".'address'."'")->find(); $_block = update_str_dq($_block, session('sys_areainfo')); $_block_content = ''; i); $_navlist = $_category->getCategory('', $_typeid, true); $_navlist = $_category->unlimitedForLayer($_navlist); foreach($_navlist as $autoindex => $nav): $_limit_list = explode(',', $_limit); if(count($_limit_list) > 1){ if(($autoindex < $_limit_list[0]) || ($autoindex > $_limit_list[1])) continue; } else{ if($autoindex >= $_limit) break; } $navmainurl = $nav['catmainurl'] ? false : true; $nav['url'] = $_category->getCategoryUrl($nav, [] , $navmainurl); $nav = update_str_dq($nav, session('sys_areainfo')); ?>|徐州联系我们

  • $v): $mod = ($i % 2 );++$i;?>

    class="on">

  • 热销产品
      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')); ?>
    • <?php echo $list['title']; ?>
    联系我们

    地址: where("title='".'address'."'")->find(); $_block = update_str_dq($_block, session('sys_areainfo')); $_block_content = ''; i); $_navlist = $_category->getCategory('', $_typeid, true); $_navlist = $_category->unlimitedForLayer($_navlist); foreach($_navlist as $autoindex => $nav): $_limit_list = explode(',', $_limit); if(count($_limit_list) > 1){ if(($autoindex < $_limit_list[0]) || ($autoindex > $_limit_list[1])) continue; } else{ if($autoindex >= $_limit) break; } $navmainurl = $nav['catmainurl'] ? false : true; $nav['url'] = $_category->getCategoryUrl($nav, [] , $navmainurl); $nav = update_str_dq($nav, session('sys_areainfo')); ?>|徐州联系我们

  • $v): $mod = ($i % 2 );++$i;?>

    class="on">

  • 热销产品
      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')); ?>
    • <?php echo $list['title']; ?>
    联系我们

    地址: where("title='".'address'."'")->find(); $_block = update_str_dq($_block, session('sys_areainfo')); $_block_content = ''; i); $_navlist = $_category->getCategory('', $_typeid, true); $_navlist = $_category->unlimitedForLayer($_navlist); foreach($_navlist as $autoindex => $nav): $_limit_list = explode(',', $_limit); if(count($_limit_list) > 1){ if(($autoindex < $_limit_list[0]) || ($autoindex > $_limit_list[1])) continue; } else{ if($autoindex >= $_limit) break; } $navmainurl = $nav['catmainurl'] ? false : true; $nav['url'] = $_category->getCategoryUrl($nav, [] , $navmainurl); $nav = update_str_dq($nav, session('sys_areainfo')); ?>|徐州联系我们

  • $v): $mod = ($i % 2 );++$i;?>

    class="on">

  • 热销产品
      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')); ?>
    • <?php echo $list['title']; ?>
    联系我们

    地址: where("title='".'address'."'")->find(); $_block = update_str_dq($_block, session('sys_areainfo')); $_block_content = ''; i); $_navlist = $_category->getCategory('', $_typeid, true); $_navlist = $_category->unlimitedForLayer($_navlist); foreach($_navlist as $autoindex => $nav): $_limit_list = explode(',', $_limit); if(count($_limit_list) > 1){ if(($autoindex < $_limit_list[0]) || ($autoindex > $_limit_list[1])) continue; } else{ if($autoindex >= $_limit) break; } $navmainurl = $nav['catmainurl'] ? false : true; $nav['url'] = $_category->getCategoryUrl($nav, [] , $navmainurl); $nav = update_str_dq($nav, session('sys_areainfo')); ?>|徐州联系我们

  • $v): $mod = ($i % 2 );++$i;?>

    class="on">

  • 热销产品
      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')); ?>
    • <?php echo $list['title']; ?>
    联系我们

    地址: where("title='".'address'."'")->find(); $_block = update_str_dq($_block, session('sys_areainfo')); $_block_content = ''; i); $_navlist = $_category->getCategory('', $_typeid, true); $_navlist = $_category->unlimitedForLayer($_navlist); foreach($_navlist as $autoindex => $nav): $_limit_list = explode(',', $_limit); if(count($_limit_list) > 1){ if(($autoindex < $_limit_list[0]) || ($autoindex > $_limit_list[1])) continue; } else{ if($autoindex >= $_limit) break; } $navmainurl = $nav['catmainurl'] ? false : true; $nav['url'] = $_category->getCategoryUrl($nav, [] , $navmainurl); $nav = update_str_dq($nav, session('sys_areainfo')); ?>|徐州联系我们

  • $v): $mod = ($i % 2 );++$i;?>

    class="on">

  • 热销产品
      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')); ?>
    • <?php echo $list['title']; ?>
    联系我们

    地址: where("title='".'address'."'")->find(); $_block = update_str_dq($_block, session('sys_areainfo')); $_block_content = ''; i); $_navlist = $_category->getCategory('', $_typeid, true); $_navlist = $_category->unlimitedForLayer($_navlist); foreach($_navlist as $autoindex => $nav): $_limit_list = explode(',', $_limit); if(count($_limit_list) > 1){ if(($autoindex < $_limit_list[0]) || ($autoindex > $_limit_list[1])) continue; } else{ if($autoindex >= $_limit) break; } $navmainurl = $nav['catmainurl'] ? false : true; $nav['url'] = $_category->getCategoryUrl($nav, [] , $navmainurl); $nav = update_str_dq($nav, session('sys_areainfo')); ?>|徐州联系我们

  • $v): $mod = ($i % 2 );++$i;?>

    class="on">

  • 热销产品
      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')); ?>
    • <?php echo $list['title']; ?>
    联系我们

    地址: where("title='".'address'."'")->find(); $_block = update_str_dq($_block, session('sys_areainfo')); $_block_content = ''; i); $_navlist = $_category->getCategory('', $_typeid, true); $_navlist = $_category->unlimitedForLayer($_navlist); foreach($_navlist as $autoindex => $nav): $_limit_list = explode(',', $_limit); if(count($_limit_list) > 1){ if(($autoindex < $_limit_list[0]) || ($autoindex > $_limit_list[1])) continue; } else{ if($autoindex >= $_limit) break; } $navmainurl = $nav['catmainurl'] ? false : true; $nav['url'] = $_category->getCategoryUrl($nav, [] , $navmainurl); $nav = update_str_dq($nav, session('sys_areainfo')); ?>|徐州联系我们

  • $v): $mod = ($i % 2 );++$i;?>

    class="on">

  • 热销产品
      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')); ?>
    • <?php echo $list['title']; ?>
    联系我们

    地址: where("title='".'address'."'")->find(); $_block = update_str_dq($_block, session('sys_areainfo')); $_block_content = ''; i); $_navlist = $_category->getCategory('', $_typeid, true); $_navlist = $_category->unlimitedForLayer($_navlist); foreach($_navlist as $autoindex => $nav): $_limit_list = explode(',', $_limit); if(count($_limit_list) > 1){ if(($autoindex < $_limit_list[0]) || ($autoindex > $_limit_list[1])) continue; } else{ if($autoindex >= $_limit) break; } $navmainurl = $nav['catmainurl'] ? false : true; $nav['url'] = $_category->getCategoryUrl($nav, [] , $navmainurl); $nav = update_str_dq($nav, session('sys_areainfo')); ?>|徐州联系我们

    在线客服系统