罗江增值电信许可证代办ICP
发布时间：2024-04-28
-
-
- 微信咨询
-
-
-
- 电话咨询
- 400-700-7300
-
?php $phone = '189-1121-9358';//全局默认
$_cid = 30;
$_limit = "10";
$_keyword = -1;
$_flag = '';
$_areaid = '';//指定地区ID
$_top = '';
$_image = '-1';
$_pagesize = 1;
$_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 = 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 ($_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'://动态
$_pagearr = ['query' => request()->param()];
break;
case '3'://伪静态
$_pagearr = ['path' => ''];
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();
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("create_time desc")
->limit($_limit)
->select();
}else{
$_infolist = db('content')
->where($_where)
->order("create_time 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, config('sys.sys_area'));
/*switch ($list['id']) {
case 209: //天津
$phone = '188-2217-5630';
break;
case 208: //山西
$phone = '189-1121-9882';
break;
case 207: //广州
$phone = '134-3697-3572';
break;
case 206: //上海
$phone = '186-0215-4110';
break;
case 205: //甘肃
$phone = '189-1121-9358';
break;
case 204: //福建
$phone = '134-6660-8836';
break;
default:
break;
}*/
endforeach;?>
189-1121-9882
