function getTypeList($parm) { //if(empty($parm['type_id'])) return; $Osql = "sort_order DESC"; //查询条件 $Lsql = "{$parm['limit']}"; $pc = getCategoryCountByParentId($parm['type_id']); if ($pc > 0) { $map['is_hiden'] = 0; $map['parent_id'] = $parm['type_id']; $data = getCategoryByCondition($map, $Osql, $Lsql); } elseif (!isset($parm['notself'])) { $map['is_hiden'] = 0; $mycat = getCategoryById($parm['type_id']); $map['parent_id'] = $mycat['parent_id']; $data = getCategoryByCondition($map, $Osql, $Lsql); } //链接处理 $typefix = get_type_leve_nid($parm['type_id']); $typeu = $typefix[0]; $suffix = C("URL_HTML_SUFFIX"); foreach ($data as $key => $v) { if ($v['type_set'] == 2) { if (empty($v['type_url'])) { $data[$key]['turl'] = "javascript:alert('请在后台添加此栏目链接');"; } else { $data[$key]['turl'] = $v['type_url']; } } elseif ($parm['type_id'] == 0 || $v['parent_id'] == 0 && count($typefix) == 1) { $data[$key]['turl'] = MU("Home/{$v['type_nid']}/index", "typelist", array("suffix" => $suffix)); } else { $data[$key]['turl'] = MU("Home/{$typeu}/{$v['type_nid']}", "typelist", array("suffix" => $suffix)); } } $row = array(); $row = $data; return $row; }
function getArticleList($parm) { if (empty($parm['type_id'])) { return; } $map['type_id'] = $parm['type_id']; $Osql = "id DESC"; $field = "id,title,art_set,art_time,art_url"; if ($parm["need_content"]) { $field .= ",art_content"; } //查询条件 if ($parm['pagesize']) { //分页处理 import("ORG.Util.Page"); $count = M('article')->where($map)->count('id'); $depr = C('URL_PATHINFO_DEPR'); $cur_url = GetCurUrl(); if (preg_match("/\\/l\\/([a-zA-z-]+)\\/([\\w\\/]*)\\?l=([a-zA-z-]+)/", $cur_url) === 1) { $cur_url = preg_replace("/\\?l=([a-zA-z-]+)/", "", $cur_url); } $p = new Page($count, $parm['pagesize'], '', preg_replace(array('/.html\\/l\\/([a-zA-z-]+)\\/\\d*/', '/.html\\/\\d+/'), array('.html?l=' . LANG_SET, '.html'), ltrim($cur_url, $depr))); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 } else { $page = ""; $Lsql = "{$parm['limit']}"; } $data = M('article')->field($field)->where($map)->order($Osql)->limit($Lsql)->select(); $suffix = C("URL_HTML_SUFFIX"); $typefix = get_type_leve_nid($map['type_id']); $typeu = implode("/", $typefix); foreach ($data as $key => $v) { if ($v['art_set'] == 1) { $data[$key]['arturl'] = stripos($v['art_url'], "http://") === false ? "http://" . $v['art_url'] : $v['art_url']; } else { $data[$key]['arturl'] = MU("Home/{$typeu}", "article", array("id" => $v['id'], "suffix" => $suffix)); } } $row = array(); $row['list'] = $data; $row['page'] = $page; return $row; }
function zwgetArticleList($parm) { if (empty($parm['type_id'])) { return; } //$map['type_id'] = $parm['type_id']; $type_id = intval($parm['type_id']); $Allid = M("article_category")->field("id")->where("parent_id = {$type_id}")->select(); $newlist = array(); array_push($newlist, $parm['type_id']); foreach ($Allid as $ka => $v) { array_push($newlist, $v["id"]); } $map['type_id'] = array("in", $newlist); $Osql = "sort_order desc,id DESC"; //id DESC, $field = "id,title,art_set,art_time,art_url,art_img,art_info"; //查询条件 if ($parm['pagesize']) { //分页处理 import("ORG.Util.Page"); $count = M('article')->where($map)->count('id'); $p = new Page($count, $parm['pagesize']); $page = $p->show(); $Lsql = "{$p->firstRow},{$p->listRows}"; //分页处理 } else { $page = ""; $Lsql = "{$parm['limit']}"; } $data = M('article')->field($field)->where($map)->order($Osql)->limit($Lsql)->select(); $suffix = C("URL_HTML_SUFFIX"); $typefix = get_type_leve_nid($type_id); $typeu = implode("/", $typefix); foreach ($data as $key => $v) { if ($v['art_set'] == 1) { $data[$key]['arturl'] = stripos($v['art_url'], "http://") === false ? "http://" . $v['art_url'] : $v['art_url']; } else { $data[$key]['arturl'] = MU("Home/{$typeu}", "article", array("id" => $v['id'], "suffix" => $suffix)); } } $row = array(); $row['list'] = $data; $row['page'] = $page; return $row; }
public function news_list_add() { $jsoncode = file_get_contents("php://input"); $arr = array(); $arr = json_decode($jsoncode, true); // $arr['gtype'] = 0; // $arr['num'] = 4; // $arr['id'] = 98; if (is_array($arr) && !empty($arr['id']) && isset($arr['gtype']) && !empty($arr['num'])) { $gtype = $arr['gtype']; $id = intval($arr['id']); $num = intval($arr['num']); } else { $gtype = 2; $num = 7; } // $listid = M('article_category')->where("type_name = '行业新闻'")->getField('id'); $listid = 2; if ($gtype == 1) { //往大查询 $list = M('article')->where("type_id = {$listid} and id > {$id} ")->order('id asc')->limit("{$num}")->select(); } elseif ($gtype == 0) { //往小查询 $list = M('article')->where("type_id = {$listid} and id < {$id} ")->order('id desc')->limit("{$num}")->select(); } elseif ($gtype == 2) { // $list = M('article')->where("type_id = {$listid} ")->order('id desc')->limit("{$num}")->select(); } $newlist = array(); $map['type_id'] = array("in", $newlist); $suffix = C("URL_HTML_SUFFIX"); $typefix = get_type_leve_nid($map['type_id']); $typeu = implode("/", $typefix); // var_dump($list);die(); foreach ($list as $key => $v) { $_list[$key]['id'] = $v['id']; $_list[$key]['title'] = $v['title']; $_list[$key]['art_time'] = date("Y-m-d", $v['art_time']); $_list[$key]['arturl'] = "peizi.taoweikeji.com" . MU("Home/{$typeu}", "article", array("id" => $v['id'], "suffix" => $suffix)); $_list[$key]['content'] = str_replace(' ', '', strip_tags($v['art_content'])); } $m_list['list'] = $_list; if (is_array($m_list['list'])) { ajaxmsg($m_list); } else { ajaxmsg(); } }