123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215 |
- <?php
- define('EmpireCMSAdmin','1');
- require("../class/connect.php");
- require("../class/db_sql.php");
- require("../class/functions.php");
- require LoadLang("pub/fun.php");
- require("../data/dbcache/class.php");
- $link=db_connect();
- $empire=new mysqlquery();
- //验证用户
- $lur=is_login();
- $logininid=$lur['userid'];
- $loginin=$lur['username'];
- $loginrnd=$lur['rnd'];
- $loginlevel=$lur['groupid'];
- $loginadminstyleid=$lur['adminstyleid'];
- //ehash
- $ecms_hashur=hReturnEcmsHashStrAll();
- $classid=(int)$_GET['classid'];
- $bclassid=(int)$class_r[$classid]['bclassid'];
- //取得栏目名
- if(!$class_r[$classid][classid]||!$class_r[$classid][tbname])
- {
- printerror("ErrorUrl","history.go(-1)");
- }
- //验证权限
- $doselfinfo=CheckLevel($logininid,$loginin,$classid,"news");
- //取得模型表
- $fieldexp="<!--field--->";
- $recordexp="<!--record-->";
- //返回搜索字段列表
- function ReturnSearchOptions($enter,$field,$record){
- global $modid,$emod_r;
- $r=explode($record,$enter);
- $count=count($r)-1;
- for($i=0;$i<$count;$i++)
- {
- if(!$sr['searchallfield'])
- {
- $or="";
- }
- else
- {
- $or=" or ";
- }
- $r1=explode($field,$r[$i]);
- if($r1[1]=="special.field"||strstr($emod_r[$modid]['tbdataf'],','.$r1[1].','))
- {
- continue;
- }
- if($r1[1]=="id")
- {
- $sr['searchallfield'].=$or.$r1[1]."='[!--key--]'";
- $sr['select'].="<option value=\"".$r1[1]."\">".$r1[0]."</option>";
- continue;
- }
- $sr['searchallfield'].=$or.$r1[1]." like '%[!--key--]%'";
- $sr['select'].="<option value=\"".$r1[1]."\">".$r1[0]."</option>";
- }
- return $sr;
- }
- $modid=(int)$class_r[$classid][modid];
- $infomod_r=$empire->fetch1("select enter,tbname,sonclass,listfile from {$dbtbpre}enewsmod where mid=".$modid);
- if(empty($infomod_r['tbname']))
- {
- printerror("ErrorUrl","history.go(-1)");
- }
- $infomod_r['enter'].='发布者<!--field--->username<!--record-->ID<!--field--->id<!--record-->关键字<!--field--->keyboard<!--record-->';
- $searchoptions_r=ReturnSearchOptions($infomod_r['enter'],$fieldexp,$recordexp);
- //审核表
- $search='';
- $search.=$ecms_hashur['ehref'];
- $addecmscheck='';
- $ecmscheck=(int)$_GET['ecmscheck'];
- $indexchecked=1;
- if($ecmscheck)
- {
- $search.='&ecmscheck='.$ecmscheck;
- $addecmscheck='&ecmscheck='.$ecmscheck;
- $indexchecked=0;
- }
- $infotb=ReturnInfoMainTbname($class_r[$classid][tbname],$indexchecked);
- //导航
- $url=AdminReturnClassLink($classid).' > 管理归档 (<a href="AddNews.php?enews=AddNews&bclassid='.$bclassid.'&classid='.$classid.$addecmscheck.$ecms_hashur['ehref'].'">增加信息</a>)';
- $start=0;
- $page=(int)$_GET['page'];
- $page=RepPIntvar($page);
- $line=intval($public_r['hlistinfonum']);//每页显示
- $page_line=16;
- $offset=$page*$line;
- $search.="&bclassid=$bclassid&classid=$classid";
- $add='';
- $ewhere='';
- //搜索
- $sear=RepPostStr($_GET['sear'],1);
- if($sear)
- {
- $keyboard=RepPostVar2($_GET['keyboard']);
- $show=RepPostVar($_GET['show']);
- //关键字
- if($keyboard)
- {
- //搜索全部
- if(!$show)
- {
- $add=" and (".str_replace("[!--key--]",$keyboard,$searchoptions_r['searchallfield']).")";
- }
- //搜索字段
- elseif($show&&strstr($infomod_r['enter'],"<!--field--->".$show."<!--record-->"))
- {
- $add=$show!="id"?" and (".$show." like '%$keyboard%')":" and (".$show."='$keyboard')";
- $searchoptions_r['select']=str_replace(" value=\"".$show."\">"," value=\"".$show."\" selected>",$searchoptions_r['select']);
- }
- }
- //标题分类
- $ttid=(int)$_GET['ttid'];
- if($ttid)
- {
- $add.=" and ttid='$ttid'";
- }
- $search.="&sear=1&keyboard=$keyboard&show=$show&ttid=$ttid";
- }
- //只能编辑自己的信息
- if($doselfinfo['doselfinfo'])
- {
- $add.=" and userid='$logininid' and ismember=0";
- }
- //单栏目单表
- $singletable=0;
- if($infomod_r[sonclass]=='|'.$classid.'|')
- {
- $singletablenum=$empire->gettotal("select count(*) as total from {$dbtbpre}enewsclass where tbname='".$class_r[$classid][tbname]."' and islast=1");
- $singletable=$singletablenum==1?1:0;
- }
- if($infomod_r[sonclass]=='|'.$classid.'|'&&$singletable==1)
- {
- $ewhere=$add?' where '.substr($add,5):'';
- }
- else
- {
- $ewhere=" where classid='$classid'".$add;
- }
- //统计
- $totalquery="select count(*) as total from {$dbtbpre}ecms_".$class_r[$classid][tbname]."_doc".$ewhere;
- $totalnum=(int)$_GET['totalnum'];
- if($totalnum<1)
- {
- $num=$empire->gettotal($totalquery);//取得总条数
- }
- else
- {
- $num=$totalnum;
- }
- //排序
- $myorder=RepPostStr($_GET['myorder'],1);
- if($myorder==1)//时间
- {$doorder="newstime desc";}
- elseif($myorder==2)//评论数
- {$doorder="plnum desc";}
- elseif($myorder==3)//人气
- {$doorder="onclick desc";}
- elseif($myorder==4)//ID号
- {$doorder="id desc";}
- else//默认排序
- {
- $thisclassr=$empire->fetch1("select listorder from {$dbtbpre}enewsclass where classid='$classid'");
- if(empty($thisclassr[listorder]))
- {
- $doorder="id desc";
- }
- else
- {
- $doorder=$thisclassr[listorder];
- }
- }
- $search.="&totalnum=$num";
- $search1=$search;
- $search.="&myorder=$myorder";
- $returnpage=page2($num,$line,$page_line,$start,$page,$search);
- $phpmyself=urlencode(eReturnSelfPage(1));
- //标题分类
- $tts='';
- $ttsql=$empire->query("select typeid,tname from {$dbtbpre}enewsinfotype where mid='$modid' order by myorder");
- while($ttr=$empire->fetch($ttsql))
- {
- $select='';
- if($ttr[typeid]==$ttid)
- {
- $select=' selected';
- }
- $tts.="<option value='$ttr[typeid]'".$select.">$ttr[tname]</option>";
- }
- $stts=$tts?"<select name='ttid'><option value='0'>标题分类</option>$tts</select>":"";
- //栏目链接
- $getcurlr['classid']=$classid;
- $classurl=sys_ReturnBqClassname($getcurlr,9);
- //导入页面
- $deftempfile=ECMS_PATH.'e/data/html/list/doclistinfo.php';
- if($infomod_r[listfile])
- {
- $tempfile=ECMS_PATH.'e/data/html/list/doc'.$infomod_r[listfile].'.php';
- if(!file_exists($tempfile))
- {
- $tempfile=$deftempfile;
- }
- }
- else
- {
- $tempfile=$deftempfile;
- }
- require($tempfile);
- db_close();
- $empire=null;
- ?>
|