新闻资讯
- $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'));
?>
- 1970-01-01
- $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'));
?>
- 1970-01-01
- $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'));
?>
- 1970-01-01
在线客服系统
