<%@page contentType="text/html; charset=UTF-8"%>
<jsp:include page="header.jsp" flush="false" />
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.myui.*,com.csc.library.util.*"%>
<%@page import="com.csc.library.utilities.*"%>
<jsp:useBean id="task" class="com.csc.library.system.Task" scope="page" />
<jsp:useBean id="task1" class="com.csc.library.system.Task" scope="page" />
<jsp:useBean id="task2" class="com.csc.library.system.Task" scope="page" />
<jsp:useBean id="task3" class="com.csc.library.system.Task" scope="page" />
<%
ThaiUtilities th=new ThaiUtilities();
String companyId=request.getParameter("__company_id");if(companyId==null)companyId="";
String companyName=request.getParameter("WB_COMPANY@TDESC");if(companyName==null)companyName="";else companyName=th.ASCII2Unicode(companyName);

String userId=request.getParameter("__user_id");if(userId==null)userId="";
String userName=request.getParameter("WB_USER@USER_NAME");if(userName==null)userName="";else userName=th.ASCII2Unicode(userName);

String screenName=request.getParameter("__screen_name");if(screenName==null)screenName="";

String startDate=request.getParameter("__start_date");if(startDate==null)startDate="";
String endDate=request.getParameter("__end_date");if(endDate==null)endDate="";

String fixCon=request.getParameter("__fixConParam");
	if(fixCon==null)
		fixCon="";
	else
		fixCon+=" and ";	

	task.setChannel(request, response);
	HelpEntry screen = (HelpEntry) task.process("HelpEntry", "WB_TOPICHELP");
	screen.getInquiry().setFilter(fixCon+"no_answer_status = '1'");
	screen.process();

	task1.setChannel(request, response);
	HelpEntry screen1 = (HelpEntry) task1.process("HelpEntry", "WB_TOPICHELP");
	screen1.getInquiry().setFilter(fixCon+"request_status = '1'");
	screen1.process();

	task2.setChannel(request, response);
	HelpEntry screen2 = (HelpEntry) task2.process("HelpEntry", "WB_TOPICHELP");
	screen2.getInquiry().setFilter(fixCon+"unsuitable_status = '1'");
	screen2.process();

	task3.setChannel(request, response);
	HelpEntry screen3 = (HelpEntry) task3.process("HelpEntry", "WB_TOPICHELP");
	screen3.getInquiry().setFilter(fixCon+"LOCK_STATUS = '1'");
	screen3.process();
	
  	CheckUser ch=new CheckUser();
	ch.setRequest(request);	
	ch.process();
	
	


%>

<script language="JavaScript" src="../../JS/SCREEN.js"></script>
<script language="JavaScript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="JavaScript" src='../../JS/VIEWCALENDAR.js'></script>
<script language="JavaScript" src='../../JS/ICONSMENU.js'></script>
<script language='javascript' src='../../JS/HOTKEY.js'></script>
<script>

function goHelp(helpName,inputName){
  with(document.cscform){
	var helpReturn="";
	var fcon=__fixCon.value;
		 if(inputName=="__company_id" )
		 	helpReturn="__company_id:company_id,WB_COMPANY@TDESC";		 
		 if(inputName=="__user_id" )
		 	helpReturn="__user_id:user_id,WB_USER@USER_NAME";		 
		 if(fcon=="")
	     	linkHelp_Return(helpName,helpReturn);
	     else 	
	     	helpPageCon(helpName,helpReturn,fcon);     
	}     
}
function goEnter(){
  		if (window.event && window.event.keyCode == 13){
  			   cal(goSearch());
  		}
}
function goSearch(){
	with(document.cscform){
		__fixConParam.value="";	
		if(__company_id.value != ""){
			__fixConParam.value="company_id='"+__company_id.value+"'";
		}
		if(__user_id.value != ""){
			if(__fixConParam.value=="")	
				__fixConParam.value="create_by='"+__user_id.value+"'";
			else
				__fixConParam.value+=" and create_by='"+__user_id.value+"'";	
		}
		if(__screen_name.value != ""){
			if(__fixConParam.value=="")	
				__fixConParam.value="screen_name='"+__screen_name.value+"'";
			else
				__fixConParam.value+=" and screen_name='"+__screen_name.value+"'";	
		}
		
		
	  if(__start_date.value !="" && __end_date.value==""){
			if(__fixConParam.value !=""){
				__fixConParam.value+=" and ";
			}
			__fixConParam.value+=" (create_date='"+subDate(__start_date.value)+"')";
		}else if(__start_date.value!="" && __end_date.value !="") {
			if(__fixConParam.value !=""){
				__fixConParam.value+=" and ";
			}
			__fixConParam.value+=" (create_date between '"+subDate(__start_date.value)+"' and '"+subDate(__end_date.value)+"')";
		}
		
		
		
		action="index.jsp";
		submit();
		
	}
}
function subDate(sDate){
	var day=sDate.substring(0,2);
	var month=sDate.substring(3,5);
	var year=sDate.substring(6,10);
	var totalDate =year+"-"+month+"-"+day;
	return totalDate;
}
</script>
<span class="divbar">Forums Administrator Panel </span> <br />
<br />
<form name="cscform" method="post">
<input type="hidden" name="__fixConParam">
<input type="hidden" name="__fixCon">
<input  type="hidden" name="__cmd"  value=""> 
<input type="hidden" name="__screen" value="index"> 
<input  type="hidden" name="__help" value=""> 

<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> 
<input type="hidden" name="__language" value ="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__calendar" value="">
<script language="javascript">getInputFormatDate();</script>



<table width="99%" border="0" align="center" cellpadding="0" cellspacing="3">
  <tr>
    <td width="20%" valign="top">
	<jsp:include page="menu.jsp" flush="false" />
	
	
	
	</td>
    <td width="80%" valign="top"><table width="100%" border="1" align="center" cellpadding="0"  cellspacing="0" bordercolor="#FFFFFF">
      <tr>
        <td bordercolor="#000000"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#4F5D6F">
          <tr>
            <td class="maintitle"><div align="left">Admin Dash Board</div></td>
          </tr>
          <tr>
            <td class="subtitle">&nbsp;&nbsp; ค้นหา</td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td bordercolor="#CCCCCC"><table width="100%" border="0" cellspacing="1" cellpadding="0">
          <tr>
            <td width="14%" class="td02"><div align="right">บริษัท :</div></td>
            <td class="td02">
<INPUT TYPE='text' Name='__company_id' SIZE='10' MAXLENGTH='10' VALUE='<%=companyId %>'  onMouseOver="toolTip('บริษัท')" onMouseOut="toolTip()" onKeyPress="chkSpecialStr(event);goEnter();"  dir="" onBlur="trimValue(this);" onFocus="this.select();" class="" alt="รหัสบริษัท"  >&nbsp; 
<A href="javascript: goHelp('WB_COMPANYHELP','__company_id');"  onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('__comid_image','','../images/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../images/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__comid_image" width="20" height="20" border="0" align="absmiddle"  ></a> 
<input name='WB_COMPANY@TDESC' type='text' readonly dir="" onFocus="this.select();" onBlur="" onChange=""  onClick="" onMouseOver="toolTip('บริษัท')" onMouseOut="toolTip()" onKeyPress="" onKeyUp="" value="<%=companyName %>" size='30' maxlength='50'>
			</td>             
          </tr>
          <tr>               
            <td width="14%" class="td02"><div align="right">ผู้ใช้งาน :</div></td>
            <td class="td02">
<INPUT TYPE='text' Name='__user_id' SIZE='10' MAXLENGTH='10' VALUE='<%=userId %>'  onClick="" onChange="" onMouseOver="toolTip('ผู้ใช้งาน')" onMouseOut="toolTip()" onKeyPress="chkSpecialStr(event);goEnter();"  dir="" onBlur="trimValue(this);" onFocus="this.select();" class="" alt="ผู้ใช้งาน"  >&nbsp; 
<A href="javascript: goHelp('WB_USERHELP','__user_id');"  onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('__typeid_image','','../images/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../images/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__typeid_image" width="20" height="20" border="0" align="absmiddle"  ></a> 
<input name='WB_USER@USER_NAME' type='text' readonly dir="" onFocus="this.select();" onBlur="" onChange=""  onClick="" onMouseOver="toolTip('ผู้ใช้งาน')" onMouseOut="toolTip()" onKeyPress="" onKeyUp="" value="<%=userName %>" size='30' maxlength='50'>
          </tr>
           
          <tr>
            <td class="td02"><div align="right">ช่วงวันที่ :</div></td>
            <td class="td02">
            <INPUT TYPE='text' Name='__start_date' SIZE='10' MAXLENGTH='10' VALUE='<%=startDate %>'  onClick="" onChange="" onMouseOver="toolTip('วันที่เริ่มต้น')" onMouseOut="toolTip()" onKeyPress="chkInteger(event);goEnter();" onKeyUp="formatDate(this);" dir="" onBlur="chkInputDate2(this,__end_date);" onFocus="this.select();" class="" alt="วันที่เริ่มต้น"  >
            &nbsp;<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1111','','../../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('__start_date')"><img src="../../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image1111" width="20" height="20" border="0" align="absmiddle" id="Image111"></a>
            &nbsp;-&nbsp;<INPUT TYPE='text' Name='__end_date' SIZE='10' MAXLENGTH='10' VALUE='<%=endDate %>'  onClick="" onChange="" onMouseOver="toolTip('วันที่สิ้นสุด')" onMouseOut="toolTip()" onKeyPress="chkInteger(event);goEnter();" onKeyUp="formatDate(this);" dir="" onBlur="chkInputDate2(__start_date,this);" onFocus="this.select();" class="" alt="วันที่สิ้นสุด"  >
            &nbsp;<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image11112','','../../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('__end_date')"><img src="../../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image11112" width="20" height="20" border="0" align="absmiddle" id="Image1112"></a>
            </td>
          </tr>
           
          <tr>
            <td class="td02"><div align="right">รหัสหน้าจอ :</div></td>
            <td class="td02"><input type="text" value="<%=screenName%>" name="__screen_name" id="__screen_name" onKeyPress="goEnter();"/></td>
          </tr>
          <tr>
            <td colspan="2" class="td02"><table width="95%" border="0" cellspacing="1" cellpadding="0">
                <tr>
                  <td><div align="right"><a href="javascript:goSearch()"><img src="images/search.gif" width="60" height="22" /></a></div></td>
                </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
    </table>
      <table width="100%" border="1" align="center" cellpadding="0"  cellspacing="0" bordercolor="#FFFFFF">
        <tr>
          <td bordercolor="#000000"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#4F5D6F">
            <tr>
              <td class="subtitle">&nbsp;&nbsp; กระทู้ที่ยังไม่ได้ตอบ</td>
            </tr>
          </table></td>
        </tr>
        <tr>
          <td bordercolor="#CCCCCC"><table width="100%" border="0" cellspacing="1" cellpadding="0">
            <tr>
              <td width="44%" class="td01"><div align="center">หัวข้อ</div></td>
              <td width="24%" class="td01"><div align="center">วันที่ตั้งกระทู้</div></td>
              <td width="16%" class="td01"><div align="center">ตอบล่าสุดโดย</div></td>
              <td width="16%" class="td01"><div align="center">วันที่ตอบ</div></td>
            </tr>
            <%
            
            while(screen.nextRec()){
            %>
            <tr>
              <td class="td02"><a href="../topicdetail.jsp?__fixCon=topic_id='<%=screen.getString("topic_id") %>'" target="_blank"><%=screen.getString("title") %></a></td>
              <td class="td02"><div align="center"><%=ch.getDateFormat(screen.getString("create_date"))+" "+screen.getString("create_time") %></div></td>
              <td class="td02"><div align="center"><%=screen.getString("last_post_user") %></div></td>
              <td class="td02"><div align="center"><%=screen.getString("last_post_date")%></div></td>
            </tr>
            <%} %>
          </table></td>
        </tr>
      </table>  
      <table width="100%" border="1" align="center" cellpadding="0"  cellspacing="0" bordercolor="#FFFFFF">
        <tr>
          <td bordercolor="#000000"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#4F5D6F">
            <tr>
              <td class="subtitle">&nbsp;&nbsp; กระทู้ที่ถูกร้องเรียน</td>
            </tr>
          </table></td>
        </tr>
        <tr>
          <td bordercolor="#CCCCCC"><table width="100%" border="0" cellspacing="1" cellpadding="0">
            <tr>
              <td width="44%" class="td01"><div align="center">หัวข้อ</div></td>
              <td width="24%" class="td01"><div align="center">วันที่ตั้งกระทู้</div></td>
              <td width="16%" class="td01"><div align="center">ตอบล่าสุดโดย</div></td>
              <td width="16%" class="td01"><div align="center">วันที่ตอบ</div></td>
            </tr>
            <%
            while(screen1.nextRec()){
            %>
            <tr>
              <td class="td02"><a href="../topicdetail.jsp?__fixCon=topic_id=<%=screen1.getString("topic_id") %>" target="_blank"><%=screen1.getString("title") %></a></td>
              <td class="td02"><div align="center"><%=ch.getDateFormat(screen1.getString("create_date"))+" "+screen1.getString("create_time") %></div></td>
              <td class="td02"><div align="center"><%=screen1.getString("last_post_user") %></div></td>
              <td class="td02"><div align="center"><%=screen1.getString("last_post_date") %></div></td>
            </tr>
            <%} %>
          </table></td>
        </tr>
      </table>
      <table width="100%" border="1" align="center" cellpadding="0"  cellspacing="0" bordercolor="#FFFFFF">
        <tr>
          <td bordercolor="#000000"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#4F5D6F">
            <tr>
              <td class="subtitle">&nbsp;&nbsp; กระทู้ที่ไม่เหมาะสม</td>
            </tr>
          </table></td>
        </tr>
        <tr>
          <td bordercolor="#CCCCCC"><table width="100%" border="0" cellspacing="1" cellpadding="0">
            <tr>
              <td width="44%" class="td01"><div align="center">หัวข้อ</div></td>
              <td width="24%" class="td01"><div align="center">วันที่ตั้งกระทู้</div></td>
              <td width="16%" class="td01"><div align="center">ตอบล่าสุดโดย</div></td>
              <td width="16%" class="td01"><div align="center">วันที่ตอบ</div></td>
            </tr>
            <%
            while(screen2.nextRec()){
            %>
            <tr>
              <td class="td02"><a href="../topicdetail.jsp?__fixCon=topic_id=<%=screen2.getString("topic_id") %>" target="_blank"><%=screen2.getString("title") %></a></td>
              <td class="td02"><div align="center"><%=ch.getDateFormat(screen2.getString("create_date"))+" "+screen2.getString("create_time") %></div></td>
              <td class="td02"><div align="center"><%=screen2.getString("last_post_user") %></div></td>
              <td class="td02"><div align="center"><%=screen2.getString("last_post_date") %></div></td>
            </tr>
            <%} %>
          </table></td>
        </tr>
      </table>
      
       <table width="100%" border="1" align="center" cellpadding="0"  cellspacing="0" bordercolor="#FFFFFF">
        <tr>
          <td bordercolor="#000000"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#4F5D6F">
            <tr>
              <td class="subtitle">&nbsp;&nbsp; กระทู้ที่ถูก ล็อค</td>
            </tr>
          </table></td>
        </tr>
        <tr>
          <td bordercolor="#CCCCCC"><table width="100%" border="0" cellspacing="1" cellpadding="0">
            <tr>
              <td width="44%" class="td01"><div align="center">หัวข้อ</div></td>
              <td width="24%" class="td01"><div align="center">วันที่ตั้งกระทู้</div></td>
              <td width="16%" class="td01"><div align="center">ตอบล่าสุดโดย</div></td>
              <td width="16%" class="td01"><div align="center">วันที่ตอบ</div></td>
            </tr>
            <%
            while(screen3.nextRec()){
            %>
            <tr>
              <td class="td02"><a href="../topicdetail.jsp?__fixCon=topic_id=<%=screen3.getString("topic_id") %>" target="_blank"><%=screen3.getString("title") %></a></td>
              <td class="td02"><div align="center"><%=ch.getDateFormat(screen3.getString("create_date"))+" "+screen3.getString("create_time") %></div></td>
              <td class="td02"><div align="center"><%=screen3.getString("last_post_user") %></div></td>
              <td class="td02"><div align="center"><%=screen3.getString("last_post_date") %></div></td>
            </tr>
            <%} %>
          </table></td>
        </tr>
      </table>
      
    </td>
  </tr>
</table>
</form>
<br />

<br />
<jsp:include page="footer.jsp" flush="false" />