public function ajaxlist()
{
//整站档案_ajaxlist
$list = D("Archives");
$order = !empty($_REQUEST["order"]) ? $_REQUEST["order"] : $list->getPk();
//排序字段,默认为"Pk"
$sortd = !empty($_REQUEST["sort"]) ? $_REQUEST["sort"] : "asc";
//排序顺序,默认为"asc"
$orderBy = $order . " " . $sortd;
//组合排序条件
$feilds = 'typeid,typeid2,industry,bycity,cid,uid,flag,ismake,channel,arcrank,click,title,shorttitle,color,writer,source,litpic,pubdate,senddate,keywords,lastpost,star1,star2,star3,star4,star5,goodpost,badpost,notpost,description,filename,uip,lastview,editpwd,showstart,showend,editer,edittime,albumid,albumnum,itype,category,telephone,fax,mobphone,email,oicq,msn,maps,city_id,zone_id,street_id,position,contact,ltdid,linkman,id';
$condition = array();
//搜索的条件
//$condition['title']=array('like',"a%");//高级搜索过滤
if (!empty($_REQUEST['searchkey'])) {
//搜索相关
$searchkey = $_REQUEST["searchkey"];
$searchtype = !empty($_REQUEST['searchtype']) ? $_REQUEST['searchtype'] : 'OR';
//默认的公共搜索条件为OR
$this->assign("searchkey", $_REQUEST["searchkey"]);
//显示关键字
$this->assign("searchurl", $_SERVER["REQUEST_URI"]);
//当前的URL
$this->assign("searchtype", $_REQUEST["searchtype"]);
//当前的搜索类型
$ser_c = array('like', "%{$searchkey}%");
//公共的过滤条件
$condition['id'] = array(id, $searchtype);
//模糊搜索关键字全局过滤
}
if (!empty($_REQUEST['channel'])) {
$condition['channel'] = $_REQUEST['channel'];
}
$count = $list->where($condition)->count();
//获取分页总数量
$p = new ajaxpage($count);
$page = $p->ajaxshow();
//显示分页
$this->assign("page", $page);
//显示分页
$limit = $p->firstRow . "," . $p->listRows;
//设定分面的大小
$limit = $limit == "," ? '' : $limit;
//分页的大小
$list = $list->where($condition)->field($feilds)->order($orderBy)->limit($limit)->findAll();
$this->assign("list", $list);
$this->display("Archives:ajaxlist");
}
public function ajaxlist()
{
//个人心情_ajaxlist
$list = D("Doing");
$order = !empty($_REQUEST["order"]) ? $_REQUEST["order"] : $list->getPk();
//排序字段,默认为"Pk"
$sortd = !empty($_REQUEST["sort"]) ? $_REQUEST["sort"] : "asc";
//排序顺序,默认为"asc"
$orderBy = $order . " " . $sortd;
//组合排序条件
$feilds = 'uid,username,tags,from,dateline,message,ip,replynum,mood,id';
$condition = array();
//搜索的条件
//$condition['title']=array('like',"a%");//高级搜索过滤
if (!empty($_REQUEST['searchkey'])) {
//搜索相关
$searchkey = $_REQUEST["searchkey"];
$searchtype = !empty($_REQUEST['searchtype']) ? $_REQUEST['searchtype'] : 'OR';
//默认的公共搜索条件为OR
$this->assign("searchkey", $_REQUEST["searchkey"]);
//显示关键字
$this->assign("searchurl", $_SERVER["REQUEST_URI"]);
//当前的URL
$this->assign("searchtype", $_REQUEST["searchtype"]);
//当前的搜索类型
$ser_c = array('like', "%{$searchkey}%");
//公共的过滤条件
$condition['id'] = array(id, $searchtype);
//模糊搜索关键字全局过滤
}
$count = $list->where($condition)->count();
//获取分页总数量
$p = new ajaxpage($count);
$page = $p->ajaxshow();
//显示分页
$this->assign("page", $page);
//显示分页
$limit = $p->firstRow . "," . $p->listRows;
//设定分面的大小
$limit = $limit == "," ? '' : $limit;
//分页的大小
$list = $list->where($condition)->field($feilds)->order($orderBy)->limit($limit)->findAll();
$this->assign("list", $list);
$this->display();
}
public function ajaxlist()
{
//公司信息_ajaxlist
$list = D("Ltd");
$order = !empty($_REQUEST["order"]) ? $_REQUEST["order"] : $list->getPk();
//排序字段,默认为"Pk"
$sortd = !empty($_REQUEST["sort"]) ? $_REQUEST["sort"] : "asc";
//排序顺序,默认为"asc"
$orderBy = $order . " " . $sortd;
//组合排序条件
$feilds = 'uid,title,passwd,info,jyfw,yyzz,zstitle1,zssm1,zspic1,zstitle2,zssm2,zspic2,zstitle3,zssm3,zspic3,zstitle4,zssm4,zspic4,ctime,mtime,cip,mip,status,id';
$condition = array();
//搜索的条件
//$condition['title']=array('like',"a%");//高级搜索过滤
if (!empty($_REQUEST['searchkey'])) {
//搜索相关
$searchkey = $_REQUEST["searchkey"];
$searchtype = !empty($_REQUEST['searchtype']) ? $_REQUEST['searchtype'] : 'OR';
//默认的公共搜索条件为OR
$this->assign("searchkey", $_REQUEST["searchkey"]);
//显示关键字
$this->assign("searchurl", $_SERVER["REQUEST_URI"]);
//当前的URL
$this->assign("searchtype", $_REQUEST["searchtype"]);
//当前的搜索类型
$ser_c = array('like', "%{$searchkey}%");
//公共的过滤条件
$condition['id'] = array(id, $searchtype);
//模糊搜索关键字全局过滤
}
$count = $list->where($condition)->count();
//获取分页总数量
$p = new ajaxpage($count);
$page = $p->ajaxshow();
//显示分页
$this->assign("page", $page);
//显示分页
$limit = $p->firstRow . "," . $p->listRows;
//设定分面的大小
$limit = $limit == "," ? '' : $limit;
//分页的大小
$list = $list->where($condition)->field($feilds)->order($orderBy)->limit($limit)->findAll();
$this->assign("list", $list);
$this->display();
}
public function ajaxlist()
{
//发布广告的用户表_ajaxlist
$list = D("AdUser");
$order = !empty($_REQUEST["order"]) ? $_REQUEST["order"] : $list->getPk();
//排序字段,默认为"Pk"
$sortd = !empty($_REQUEST["sort"]) ? $_REQUEST["sort"] : "asc";
//排序顺序,默认为"asc"
$orderBy = $order . " " . $sortd;
//组合排序条件
$feilds = 'ad_id,u_uid,u_username,u_day,u_begintime,u_endtime,u_hits,u_yz,u_code,u_money,u_moneycard,u_posttime,id';
$condition = array();
//搜索的条件
//$condition['title']=array('like',"a%");//高级搜索过滤
if (!empty($_REQUEST['searchkey'])) {
//搜索相关
$searchkey = $_REQUEST["searchkey"];
$searchtype = !empty($_REQUEST['searchtype']) ? $_REQUEST['searchtype'] : 'OR';
//默认的公共搜索条件为OR
$this->assign("searchkey", $_REQUEST["searchkey"]);
//显示关键字
$this->assign("searchurl", $_SERVER["REQUEST_URI"]);
//当前的URL
$this->assign("searchtype", $_REQUEST["searchtype"]);
//当前的搜索类型
$ser_c = array('like', "%{$searchkey}%");
//公共的过滤条件
$condition['id'] = array(id, $searchtype);
//模糊搜索关键字全局过滤
}
$count = $list->where($condition)->count();
//获取分页总数量
$p = new ajaxpage($count);
$page = $p->ajaxshow();
//显示分页
$this->assign("page", $page);
//显示分页
$limit = $p->firstRow . "," . $p->listRows;
//设定分面的大小
$limit = $limit == "," ? '' : $limit;
//分页的大小
$list = $list->where($condition)->field($feilds)->order($orderBy)->limit($limit)->findAll();
$this->assign("list", $list);
$this->display();
}
public function ajaxlist()
{
//点击统计综合_ajaxlist
$list = D("Stat");
$order = !empty($_REQUEST["order"]) ? $_REQUEST["order"] : $list->getPk();
//排序字段,默认为"Pk"
$sortd = !empty($_REQUEST["sort"]) ? $_REQUEST["sort"] : "asc";
//排序顺序,默认为"asc"
$orderBy = $order . " " . $sortd;
//组合排序条件
$feilds = 'xid,mon,stype,d01,d02,d03,d04,d05,d06,d07,d08,d09,d10,d11,d12,d13,d14,d15,d16,d17,d18,d19,d20,d21,d22,d23,d24,d25,d26,d27,d28,d29,d30,d31,id';
$condition = array();
//搜索的条件
//$condition['title']=array('like',"a%");//高级搜索过滤
if (!empty($_REQUEST['searchkey'])) {
//搜索相关
$searchkey = $_REQUEST["searchkey"];
$searchtype = !empty($_REQUEST['searchtype']) ? $_REQUEST['searchtype'] : 'OR';
//默认的公共搜索条件为OR
$this->assign("searchkey", $_REQUEST["searchkey"]);
//显示关键字
$this->assign("searchurl", $_SERVER["REQUEST_URI"]);
//当前的URL
$this->assign("searchtype", $_REQUEST["searchtype"]);
//当前的搜索类型
$ser_c = array('like', "%{$searchkey}%");
//公共的过滤条件
$condition['id'] = array(id, $searchtype);
//模糊搜索关键字全局过滤
}
$count = $list->where($condition)->count();
//获取分页总数量
$p = new ajaxpage($count);
$page = $p->ajaxshow();
//显示分页
$this->assign("page", $page);
//显示分页
$limit = $p->firstRow . "," . $p->listRows;
//设定分面的大小
$limit = $limit == "," ? '' : $limit;
//分页的大小
$list = $list->where($condition)->field($feilds)->order($orderBy)->limit($limit)->findAll();
$this->assign("list", $list);
$this->display();
}
public function ajaxlist()
{
//城市和地区表_ajaxlist
$list = D("Area");
$order = !empty($_REQUEST["order"]) ? $_REQUEST["order"] : $list->getPk();
//排序字段,默认为"Pk"
$sortd = !empty($_REQUEST["sort"]) ? $_REQUEST["sort"] : "asc";
//排序顺序,默认为"asc"
$orderBy = $order . " " . $sortd;
//组合排序条件
$feilds = 'fup,name,class,sons,type,admin,list,listorder,passwd,logo,descrip,style,template,jumpurl,maxperpage,metakeywords,metadescription,allowcomment,allowpost,allowviewtitle,allowviewcontent,allowdownload,forbidshow,config,id';
$condition = array();
//搜索的条件
//$condition['title']=array('like',"a%");//高级搜索过滤
if (!empty($_REQUEST['searchkey'])) {
//搜索相关
$searchkey = $_REQUEST["searchkey"];
$searchtype = !empty($_REQUEST['searchtype']) ? $_REQUEST['searchtype'] : 'OR';
//默认的公共搜索条件为OR
$this->assign("searchkey", $_REQUEST["searchkey"]);
//显示关键字
$this->assign("searchurl", $_SERVER["REQUEST_URI"]);
//当前的URL
$this->assign("searchtype", $_REQUEST["searchtype"]);
//当前的搜索类型
$ser_c = array('like', "%{$searchkey}%");
//公共的过滤条件
$condition['id'] = array(id, $searchtype);
//模糊搜索关键字全局过滤
}
$count = $list->where($condition)->count();
//获取分页总数量
$p = new ajaxpage($count);
$page = $p->ajaxshow();
//显示分页
$this->assign("page", $page);
//显示分页
$limit = $p->firstRow . "," . $p->listRows;
//设定分面的大小
$limit = $limit == "," ? '' : $limit;
//分页的大小
$list = $list->where($condition)->field($feilds)->order($orderBy)->limit($limit)->findAll();
$this->assign("list", $list);
$this->display();
}
public function ajaxlist()
{
//群组信息_ajaxlist
$list = D("Group");
$order = !empty($_REQUEST["order"]) ? $_REQUEST["order"] : $list->getPk();
//排序字段,默认为"Pk"
$sortd = !empty($_REQUEST["sort"]) ? $_REQUEST["sort"] : "asc";
//排序顺序,默认为"asc"
$orderBy = $order . " " . $sortd;
//组合排序条件
$feilds = 'groupname,tags,membernum,threadnum,postnum,close,announcement,pic,closeapply,joinperm,viewperm,threadperm,postperm,recommend,moderator,cat_id,fcat_id,attr,ctime,lasttime,en,description,id';
$condition = array();
//搜索的条件
//$condition['title']=array('like',"a%");//高级搜索过滤
if (!empty($_REQUEST['searchkey'])) {
//搜索相关
$searchkey = $_REQUEST["searchkey"];
$searchtype = !empty($_REQUEST['searchtype']) ? $_REQUEST['searchtype'] : 'OR';
//默认的公共搜索条件为OR
$this->assign("searchkey", $_REQUEST["searchkey"]);
//显示关键字
$this->assign("searchurl", $_SERVER["REQUEST_URI"]);
//当前的URL
$this->assign("searchtype", $_REQUEST["searchtype"]);
//当前的搜索类型
$ser_c = array('like', "%{$searchkey}%");
//公共的过滤条件
$condition['id'] = array(id, $searchtype);
//模糊搜索关键字全局过滤
}
$count = $list->where($condition)->count();
//获取分页总数量
$p = new ajaxpage($count);
$page = $p->ajaxshow();
//显示分页
$this->assign("page", $page);
//显示分页
$limit = $p->firstRow . "," . $p->listRows;
//设定分面的大小
$limit = $limit == "," ? '' : $limit;
//分页的大小
$list = $list->where($condition)->field($feilds)->order($orderBy)->limit($limit)->findAll();
$this->assign("list", $list);
$this->display();
}
/**
*显示我的群组
*@date 2010-6-28
*@time 下午03:38:35
*/
public function ajax_group()
{
//显示我的群组
if (!$this->_is_login()) {
$this->error("Log On Please");
} else {
$id = explode('_', $_REQUEST['id']);
$xid = $_REQUEST['xid'];
$xtype = $_REQUEST['xtype'];
$this->assign('xid', $xid);
$this->assign('xtype', $xtype);
$dao = D("Tagspace");
$condition = array();
$condition['uid'] = $this->user['uid'];
$count = $dao->where($condition)->count();
if ($count != '0') {
import("ORG.Util.Page");
//引用分页类
import("@.Com.ajaxpage");
//引用ajax分页类
$p = new ajaxpage($count, 10);
$page = $p->ajaxshow();
//显示分页
$this->assign("showpage_bot", $page);
//显示分页
$limit = $p->firstRow . "," . $p->listRows;
//设定分面的大小
$limit = $limit == "," ? '' : $limit;
//分页的大小
$data = $dao->where($condition)->order("ctime DESC")->limit($limit)->findAll();
$info = array();
foreach ($data as $v) {
$info[$v['tagid']] = get_info($v['tagid'], '*');
}
//dump($info);
$this->assign("info", $info);
$this->display("Common:ajax_group");
} else {
$this->error("You need to join a group first.");
}
}
}
