<%@ include file="/sof_intercept_norefer.jsp" %>
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%@page import="com.ucap.system.db.*,com.ucap.gecs.base.dao.*"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>门户网站</title>
<link href="/sofpro/gecs/styles/page.css" type="text/css" rel="stylesheet" />
        <link href="/sofpro/gecs/styles/cngzlistsytle.css" rel="stylesheet" type="text/css" />
    <link href="styles/cngzlistsytle.css" rel="stylesheet" type="text/css" />
    <link href="styles/SpryTabbedPanels.css" rel="stylesheet" type="text/css" />
    <link href="\publicfiles\model\htmltemplate\gzgov\css\cngzs_new.css" rel="stylesheet" type="text/css" />
<script>
function init(){
    var tab = document.getElementById("tbody"); 
    for (var i = 0, len = tab.rows.length; i < len; i++){
        if(i%2==0){
            tab.rows[i].style.backgroundColor='#fff';
        }
        if(i%2==1){
            tab.rows[i].style.backgroundColor='#f1f1f1';
        }
    }
}
function cTb(val){
for(i =0 ; i < 9; i++){
document.getElementById("ctd"+i).style.backgroundImage="url(images/div_1_td02.gif)";
}
var obj = document.getElementById("ctd"+val);
obj.style.backgroundImage="url(images/column_bg.gif)";
obj.style.color="#ffffff";
}
</script>
<style type="text/css">
#tb21 td{
width:85px;
}
#tab21 th{
font-size:12px;
background-color:#E7D5BD
}
#tab21 td{
font-size:12px;
}
.style1 {font-size: 12px}
        .style2 {color: #FF6600}
        </style>
  </head>
  
  <body onLoad="init()">
  <div id="top"><iframe height="160px" src="/publicfiles//business/htmlfiles/xixiu/smdb/index.html" frameborder=0 width="100%" scrolling=no></iframe></div>
<table width="980" height="22" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="22" align="left"><span class="style1"><img src="list_red_07.jpg" width="14" height="14"> </span></td>
  <td width="958"><span class="style1"> 您的当前位置: <a href="../../../../business/htmlfiles/gzgov/index.html">首页 </a> &gt; <a href="/publicfiles//business/htmlfiles/gzgov/index.html">政府服务 </a> &gt; <a href="../../../../business/htmlfiles/gzgov/s2301/index.html">互动交流 </a> &gt; <a href="../../../../business/htmlfiles/gzgov/s2301/list.html">百姓热线 </a> &gt; 热点问题 </span></td>
  </tr>
</table><br>
 
  <div class="listcenter" id="content">
  <%
  DataBase dataBase = null;
com.ucap.system.db.RecordSet rs=null;
response.setCharacterEncoding("utf-8");
String oper = request.getParameter("oper") == null?"0":request.getParameter("oper");
try{
dataBase = SysDataFactory.getDataBase();
%><TABLE align="center" cellSpacing=0 width="950" cellPadding=0 style="font-size:14px; background-image:url(images/title_1_bg_02.gif); background-repeat:repeat-x; " id="tb21"  border=0>
    <tr align=center>
<td align="left"><strong>&nbsp;<span class="style2">热点问题 </span></strong></td>
<td id="ctd0" height="24px" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=0" onClick="cTb('0')">户籍</a></td>
<td  id="ctd1" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=1" onClick="cTb('1')">交通</a></td>
<td  id="ctd2" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=2" onClick="cTb('2')">人事</a></td>
<td  id="ctd3" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=3" onClick="cTb('3')">劳动保障</a></td>
<td id="ctd4"  style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=4" onClick="cTb('4')">住房</a></td>
<td  id="ctd5" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=5" onClick="cTb('5')">人口计划</a></v>
<td  id="ctd6"style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=6" onClick="cTb('6')" >物价</a></td>
<td  id="ctd7"  style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=7" onClick="cTb('7')">教育</a></td> 
<td  id="ctd8"  style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=8" onClick="cTb('8')">其他</a></td> 
<td>&nbsp;</td>          
    </TR>
</TABLE>
<br/>
<TABLE cellSpacing=0 align="center" width="940" cellPadding=2  id="tab21" border=0>        <tr>
      <Th align="center" width="92" height="24px"  nowrap>受理编号</Th>
      <Th  align="center" width="350" nowrap>主题 </Th>
      
      <Th   align="center" nowrap >作者</Th>
      <Th   align="center" nowrap >发布时间</Th>
      <Th  align="center" nowrap>状态</Th>
  <Th   align="center" nowrap>访问量</Th>
      <Th  align="center" nowrap>满意度</Th>   
    </TR>
  <TBODY id="tbody">
<%
String sql = "SELECT HOTLINE_SEQ,HOTLINE_BH_SEQ,HOTLINE_SLBH_SEQ,ZZXBH,CATEGORY,SECRECY,SUBJECT,MAKE_CONTENT,DSG_DEPT_ID,DSG_DEPT_NAME,ATCH_1,ATCH_2,ATCH_3,MAKE_NAME,MAKE_SEX,MAKE_IP,MAKE_PHONE,MAKE_MPHONE,MAKE_MAIL,MAKE_ADD,to_char(MAKE_DATE,'mm-dd') MAKE_DATE,ACCESS_AMOUNT,SAT_TIME,SAT_CONTENT,DIS_DEPT_ID,DIS_DEPT_NAME,DIS_STATUS,STATUS,PEPLY_DEPT_ID,PEPLY_DEPT_NAME,STIPULATE_PEPLY_DATE,PEPLY_DATE,PEPLY_NAME,PEPLY_CONTENT,PEPLY_ATCH,PEPLY_OPERATE,FAQ,COMMENT_STATE,PARENT_ID,HOTLINE_EXP1,HOTLINE_EXP2,HOTLINE_EXP3,SORT,USER_ID,USER_CODE,STATUS_DESCRIPTION,REPLY_NUMBER,POINT,APPELLATION,DATE_TRANSMITTED,SECRECY_MESSAGE FROM  GECS_PEOPLE_HOTLINE where HOTLINE_SEQ in( select t.hotline_seq from gecs_people_hotline_cate t where t.category='"+oper+"') order by to_number(ACCESS_AMOUNT) desc";
//out.println(sql);
rs = dataBase.execSelect(sql);
while(rs.next()){

  %>
  
          <TR>
          <TD height=24 width=92 align="left" nowrap><IMG height=9 alt="" src="images/dot03.gif" width=12 align=absMiddle><%=rs.getString("HOTLINE_SLBH_SEQ")==null?"":rs.getString("HOTLINE_SLBH_SEQ")%></TD>
          <TD align="left"  ><a href="<%="/sofpro/gecs/webview_hotline.gecs?hotline.hotlineSeq="+rs.getString("HOTLINE_SEQ")+"&flag=view"%>" target="_blank"><%=rs.getString("SUBJECT")==null?"":rs.getString("SUBJECT")%></a></TD>
          <TD align="middle" nowrap><%=rs.getString("USER_CODE")==null?"":rs.getString("USER_CODE")%></TD>
          <TD align="middle" nowrap><%=rs.getString("MAKE_DATE")==null?"":rs.getString("MAKE_DATE")%></TD>
          <TD align="middle" nowrap>
  <%=rs.getString("STATUS")==null?"":(!rs.getString("STATUS").equals("0")?"":"处理中")%>
  <%=rs.getString("STATUS")==null?"":(!rs.getString("STATUS").equals("1")?"":"已答复")%>
  <%=rs.getString("STATUS")==null?"":(!rs.getString("STATUS").equals("2")?"":"逾期未处理")%>                              
          </TD>
   <TD align="middle" nowrap title="访问量">
  <%=rs.getString("ACCESS_AMOUNT")==null?"暂无":rs.getString("ACCESS_AMOUNT")%>     
          </TD>  
          <TD align="middle" nowrap title="内容满意度">
  <%=rs.getString("SAT_CONTENT")==null?"暂无":rs.getString("SAT_CONTENT")%>     
          </TD>                    
        </TR>  
  <%}
  %></TBODY>
   </TABLE> 
  <%
 }catch(Exception e){
e.printStackTrace();
out.println(e);}finally{
  try{ 
              if(rs!=null) rs.close(); 
             
              if(dataBase!=null){ 
                dataBase.close();
              }
            }catch(Exception e){ 
               // logger.debug(e.toString()); 
                throw e; 
            } 
//out.println("<script>history.go(-1)</script>");
}
  %>
  
  </div>
  <br/>
    <div id="bottom"><IFRAME height="150px" src="/publicfiles//business/htmlfiles/xixiu/wzdb/index.html" 
frameBorder=0 width="100%" scrolling=no></IFRAME></div>
  <script>
   var val = "<%=oper%>";
document.getElementById("ctd"+val).style.backgroundImage="url(images/column_bg.gif)";
//document.getElementById("ctd"+val).getElementsById("a")[0].style.color="#FFFFFF";
var obj3 = document.getElementById("content");
//alert(obj3.clientHeight);
/*if(obj3.clientHeight <=320){
obj3.style.height=230px;
}*/
//alert(document.getElementById("ctd"+val));
  </script>
  </body>
</html>