Dede(织梦)列表页ajax调用

//判断是否ajax获取
if(isset($_GET['type']) && $_GET['type'] == "ajax"){
		header("Content-type:text/json;charset=gbk;");
		//传递过来的分类ID
		$typeid = isset($_GET['tid']) ? intval($_GET['tid']): 0;
  		//页码
  		$page = isset($_GET['page']) ? intval($_GET['page']): 0;
  		//每页多少条,也就是一次加载多少条数据
  		$pagesize = isset($_GET['pagesize']) ? intval($_GET['pagesize']): 12;
  		//数据获取的起始位置。即limit条件的第一个参数。
  		$start = $page>0 ? ($page-1)*$pagesize : 0;
  		//这个是用于首页实现瀑布流加载,因为首页加载数据是无需分类的,所以要加以判断,如果无需
		//是否有子栏目
		$dsql->SetQuery("select id from dede_arctype where topid = $typeid");
  		$dsql->Execute('list');
		$typeid = $typeid;
		while($row = $dsql->GetArray("list")){	
			$typeid .=",".$row['id'];
		}
		
  		$typesql = $typeid ? " WHERE typeid in($typeid)" : '';
  		$total_sql = "SELECT COUNT(id) as num FROM `dede_archives`  $typesql ";
  		$temp = $dsql->GetOne($total_sql);
  		$total = 0;//数据总数
  		$load_num =0;
		
		$load_num= ceil($temp['num']/$pagesize);
		$total = $temp['num'];
	
		$sql = "SELECT a.*,t.typedir,t.typename,t.isdefault,t.defaultname,t.namerule,
				t.namerule2,t.ispart, t.moresite,t.siteurl,t.sitepath
				FROM `dede_archives` as a JOIN `dede_arctype` AS t ON a.typeid=t.id  
				$typesql ORDER BY id DESC LIMIT $start,$pagesize";
		
   		$dsql->SetQuery($sql);
  		$dsql->Execute('list');
   		$statu = 0;//是否有数据,默认没有数据
   		$data = array();
   		$index = 0;
		$res = array();
		$data = array();
		while($row = $dsql->GetArray("list")){	
			$data[$index]['info'] = $row['info'] = $row['infos'] = cn_substr($row['description'],160);
			$data[$index]['id'] =  $row['id'];
			if($row['litpic'] == '-' || $row['litpic'] == ''){
			     $data[$index]['litpic'] = $GLOBALS['cfg_cmspath'].'/images/defaultpic.gif';
			}
			if(!preg_match("#^http:\/\/#i", $row['litpic']) &&$GLOBALS['cfg_multi_site'] == 'Y'){
				$data[$index]['litpic'] = $GLOBALS['cfg_mainsite'].$row['litpic'];
			}
			$data[$index]['picname'] = $row['litpic'];//缩略图
			$data[$index]['stime'] = getUtf(GetDateMK($row['pubdate']));
			$data[$index]['typelink'] = getUtf("".$row['typename']."");//分类链
			$data[$index]['fulltitle'] = getUtf($row['title']);//完整的标题
			$data[$index]['shorttitle'] = getUtf($row['shorttitle']);//副标题
			$data[$index]['title'] = getUtf(cn_substr($row['title'], 60));//截取后的标题
			$index++;
		}
		$res['data'] = $data;
		$res['pages'] = $load_num;
		echo json_encode($res);
		die();
}

  

posted @ 2017-03-21 12:27  lijia168  阅读(567)  评论(0编辑  收藏  举报
热点资讯网