doclistinfo.php 9.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225
  1. <?php
  2. if(!defined('InEmpireCMS'))
  3. {
  4. exit();
  5. }
  6. ?>
  7. <?php
  8. //查询SQL,如果要显示自定义字段记得在SQL里增加查询字段
  9. $query="select id,classid,isurl,titleurl,isqf,havehtml,istop,isgood,firsttitle,ismember,userid,username,eckuid,plnum,totaldown,onclick,newstime,truetime,lastdotime,titlepic,title from {$dbtbpre}ecms_".$class_r[$classid][tbname]."_doc".$ewhere." order by ".$doorder." limit $offset,$line";
  10. $sql=$empire->query($query);
  11. //返回头条和推荐级别名称
  12. $ftnr=ReturnFirsttitleNameList(0,0);
  13. $ftnamer=$ftnr['ftr'];
  14. $ignamer=$ftnr['igr'];
  15. ?>
  16. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  17. <html>
  18. <head>
  19. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  20. <link rel="stylesheet" href="adminstyle/<?=$loginadminstyleid?>/adminstyle.css" type="text/css">
  21. <title>管理归档</title>
  22. <script>
  23. function CheckAll(form)
  24. {
  25. for (var i=0;i<form.elements.length;i++)
  26. {
  27. var e = form.elements[i];
  28. if (e.name != 'chkall')
  29. e.checked = form.chkall.checked;
  30. }
  31. }
  32. </script>
  33. </head>
  34. <body>
  35. <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
  36. <tr>
  37. <td>位置: <?=$url?></td>
  38. </tr>
  39. </table>
  40. <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
  41. <form name="form2" method="GET" action="ListInfoDoc.php">
  42. <?=$ecms_hashur['eform']?>
  43. <tr>
  44. <td colspan="2"><table width="100%" border="0" cellpadding="3" cellspacing="1" class="tableborder">
  45. <tr>
  46. <td><div class="emenubutton">
  47. <div align="right">
  48. <input type=button name=button value=增加信息 onClick="self.location.href='AddNews.php?enews=AddNews&bclassid=<?=$bclassid?>&classid=<?=$classid?><?=$addecmscheck?><?=$ecms_hashur['ehref']?>'">
  49. &nbsp;
  50. <input type="button" name="Submit" value="刷新首页" onclick="self.location.href='ecmschtml.php?enews=ReIndex<?=$ecms_hashur['href']?>'">
  51. &nbsp;
  52. <input type="button" name="Submit22" value="刷新本栏目" onclick="self.location.href='enews.php?<?=$ecms_hashur['href']?>&enews=ReListHtml&classid=<?=$classid?>'">
  53. &nbsp;
  54. <input type="button" name="Submit4" value="刷新所有信息JS" onclick="window.open('ecmschtml.php?<?=$ecms_hashur['href']?>&enews=ReAllNewsJs&from=<?=$phpmyself?>','','');">
  55. &nbsp;
  56. <input type="button" name="Submit10" value="栏目设置" onclick="self.location.href='AddClass.php?<?=$ecms_hashur['ehref']?>&enews=EditClass&classid=<?=$classid?>'">
  57. &nbsp;
  58. <input type="button" name="Submit102" value="增加采集节点" onclick="self.location.href='AddInfoClass.php?enews=AddInfoClass&newsclassid=<?=$classid?><?=$ecms_hashur['ehref']?>'">
  59. &nbsp;
  60. <input type="button" name="Submit103" value="管理采集节点" onclick="self.location.href='ListInfoClass.php<?=$ecms_hashur['whehref']?>'">
  61. </div>
  62. </div></td>
  63. </tr>
  64. </table></td>
  65. </tr>
  66. <tr>
  67. <td width="38%">
  68. <div align="left">[<a href="InfoDoc.php<?=$ecms_hashur['whehref']?>" target="_blank">批量归档信息</a>]&nbsp;[<a href="ReHtml/ChangeData.php<?=$ecms_hashur['whehref']?>" target=_blank>更新数据</a>]&nbsp;[<a href=../../ target=_blank>预览首页</a>]&nbsp;[<a href="<?=$classurl?>" target=_blank>预览栏目</a>]</div></td>
  69. <td width="62%">
  70. <div align="right">
  71. <input name="keyboard" type="text" id="keyboard2" value="<?=$keyboard?>" size="16">
  72. <select name="show">
  73. <option value="0" selected>不限字段</option>
  74. <?=$searchoptions_r['select']?>
  75. </select>
  76. <?=$stts?>
  77. <input type="submit" name="Submit2" value="搜索">
  78. <input name="sear" type="hidden" id="sear2" value="1">
  79. <input name="bclassid" type="hidden" id="bclassid" value="<?=$bclassid?>">
  80. <input name="classid" type="hidden" id="classid" value="<?=$classid?>">
  81. <input name="ecmscheck" type="hidden" id="ecmscheck" value="<?=$ecmscheck?>">
  82. </div></td>
  83. </tr>
  84. </form>
  85. </table>
  86. <br>
  87. <form name="listform" method="post" action="ecmsinfo.php" onsubmit="return confirm('确认要执行此操作?');">
  88. <?=$ecms_hashur['form']?>
  89. <input type=hidden name=classid value=<?=$classid?>>
  90. <input type=hidden name=bclassid value=<?=$bclassid?>>
  91. <input type=hidden name=enews value=DelInfoDoc_all>
  92. <input type=hidden name=doing value=1>
  93. <input name="ecmsdoc" type="hidden" id="ecmsdoc" value="0">
  94. <input name="docfrom" type="hidden" id="docfrom" value="<?=$phpmyself?>">
  95. <input name="ecmscheck" type="hidden" id="ecmscheck" value="<?=$ecmscheck?>">
  96. <table width="100%" border="0" cellspacing="1" cellpadding="0">
  97. <tr>
  98. <td width="10%" height="25" bgcolor="#C9F1FF"><div align="center"><a href="ListNews.php?bclassid=<?=$bclassid?>&classid=<?=$classid?><?=$ecms_hashur['ehref']?>">已发布</a></div></td>
  99. <td width="10%" bgcolor="#C9F1FF"><div align="center"><a href="ListNews.php?bclassid=<?=$bclassid?>&classid=<?=$classid?>&ecmscheck=1<?=$ecms_hashur['ehref']?>">待审核</a></div></td>
  100. <td width="10%" class="header"><div align="center"><a href="ListInfoDoc.php?bclassid=<?=$bclassid?>&classid=<?=$classid?><?=$addecmscheck?><?=$ecms_hashur['ehref']?>">归档</a></div></td>
  101. <td width="58%">&nbsp;</td>
  102. <td width="6%">&nbsp;</td>
  103. <td width="6%">&nbsp;</td>
  104. </tr>
  105. </table>
  106. <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
  107. <tr class="header">
  108. <td width="7%" height="25"><div align="center"><a href='ListInfoDoc.php?<?=$search1?>&myorder=4'><u>ID</u></a></div></td>
  109. <td width="47%" height="25"> <div align="center">标题</div></td>
  110. <td width="18%" height="25"><div align="center">发布者</div></td>
  111. <td width="22%" height="25"> <div align="center"><a href='ListInfoDoc.php?<?=$search1?>&myorder=1'><u>发布时间</u></a></div></td>
  112. <td width="6%" height="25"> <div align="center">选择</div></td>
  113. </tr>
  114. <?php
  115. while($r=$empire->fetch($sql))
  116. {
  117. //状态
  118. $st='';
  119. if($r[istop])//置顶
  120. {
  121. $st.="<font color=red>[顶".$r[istop]."]</font>";
  122. }
  123. if($r[isgood])//推荐
  124. {
  125. $st.="<font color=red>[".$ignamer[$r['isgood']]."]</font>";
  126. }
  127. if($r[firsttitle])//头条
  128. {
  129. $st.="<font color=red>[".$ftnamer[$r['firsttitle']]."]</font>";
  130. }
  131. //时间
  132. $truetime=date("Y-m-d H:i:s",$r[truetime]);
  133. $lastdotime=date("Y-m-d H:i:s",$r[lastdotime]);
  134. $oldtitle=$r[title];
  135. $r[title]=stripSlashes(sub($r[title],0,50,false));
  136. $titleurl=sys_ReturnBqTitleLink($r);
  137. //会员投稿
  138. if($r[ismember])
  139. {
  140. $r[username]="<a href='member/AddMember.php?enews=EditMember&userid=".$r[userid].$ecms_hashur['ehref']."' target='_blank'><font color=red>".$r[username]."</font></a>";
  141. }
  142. //签发
  143. $qf="";
  144. if($r[isqf])
  145. {
  146. $qfr=$empire->fetch1("select checktno,tstatus from {$dbtbpre}enewswfinfo where id='$r[id]' and classid='$r[classid]' limit 1");
  147. if($qfr[checktno]=='100')
  148. {
  149. $qf="(<font color='red'>已通过</font>)";
  150. }
  151. elseif($qfr[checktno]=='101')
  152. {
  153. $qf="(<font color='red'>返工</font>)";
  154. }
  155. elseif($qfr[checktno]=='102')
  156. {
  157. $qf="(<font color='red'>已否决</font>)";
  158. }
  159. else
  160. {
  161. $qf="(<font color='red'>$qfr[tstatus]</font>)";
  162. }
  163. $qf="<a href='#ecms' onclick=\"window.open('workflow/DoWfInfo.php?classid=$r[classid]&id=$r[id]".$addecmscheck.$ecms_hashur['ehref']."','','width=600,height=520,scrollbars=yes');\">".$qf."</a>";
  164. }
  165. //标题图片
  166. $showtitlepic="";
  167. if($r[titlepic])
  168. {
  169. $showtitlepic="<a href='".$r['titlepic']."' title='预览标题图片' target=_blank><img src='../data/images/showimg.gif' border=0></a>";
  170. }
  171. //未生成
  172. $myid=$r['id'];
  173. if(empty($r[havehtml]))
  174. {
  175. $myid="<a title='未生成'><b>".$r[id]."</b></a>";
  176. }
  177. ?>
  178. <tr bgcolor="#FFFFFF" id=news<?=$r[id]?> onmouseout="this.style.backgroundColor='#ffffff'" onmouseover="this.style.backgroundColor='#C3EFFF'">
  179. <td height="32"> <div align="center">
  180. <?=$myid?>
  181. </div></td>
  182. <td height="25"> <div align="left">
  183. <?=$st?>
  184. <?=$showtitlepic?>
  185. <a href="<?=$titleurl?>" target=_blank title="<?=$oldtitle?>">
  186. <?=$r[title]?>
  187. </a>
  188. <?=$qf?>
  189. </div></td>
  190. <td height="25"<?=$r['eckuid']?' title="审核人UID:'.$r['eckuid'].'"':''?>> <div align="center">
  191. <?=$r[username]?>
  192. </div></td>
  193. <td height="25"> <div align="center"> <a href="#ecms" title="<? echo"增加时间:".$truetime."\r\n最后修改:".$lastdotime;?>">
  194. <?=date("Y-m-d H:i:s",$r[newstime])?>
  195. </a> </div></td>
  196. <td height="25"> <div align="center">
  197. <input name="id[]" type="checkbox" id="id[]" value="<?=$r[id]?>">
  198. </div></td>
  199. </tr>
  200. <?
  201. }
  202. ?>
  203. <tr bgcolor="#FFFFFF">
  204. <td height="25" colspan="4"> <table width="100%" border="0" cellpadding="0" cellspacing="0">
  205. <tr>
  206. <td width="83%">
  207. <?=$returnpage?>
  208. </td>
  209. <td width="17%"><div align="right">
  210. <input type="submit" name="Submit3" value="删除" onClick="document.listform.enews.value='DelInfoDoc_all';document.listform.action='ecmsinfo.php';">
  211. <input type="submit" name="Submit11" value="还原归档" onClick="document.listform.enews.value='InfoToDoc';document.listform.doing.value='1';document.listform.action='ecmsinfo.php';">
  212. </div></td>
  213. </tr>
  214. </table></td>
  215. <td height="25"><div align="center">
  216. <input type=checkbox name=chkall value=on onClick=CheckAll(this.form)>
  217. </div></td>
  218. </tr>
  219. <tr bgcolor="#FFFFFF">
  220. <td height="25" colspan="5"> <font color="#666666">备注:发布者红色为会员投稿;信息ID粗体为未生成.</font></td>
  221. </tr>
  222. </table>
  223. </form>
  224. </body>
  225. </html>