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."); } } }