query.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 189 行
PHP
189 行
<?
include_once 'inc/auth.php';
echo '
<html>
<head>
<title>工作计划查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript Language="JavaScript">
function clear_dept()
{
document.form1.TO_NAME.value="";
document.form1.TO_ID.value="";
}
function LoadWindow(id,desc)
{
URL="/module/dept_select_single?ID="+id+"&DESC="+desc;
loc_x=document.body.scrollLeft+event.clientX-event.offsetX;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.showModalDialog(URL,self,"edge:raised;sc';
echo 'roll:1;status:0;help:0;resizable:1;dialogWidth:200px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function LoadWindow1()
{
URL="/module/user_select_single?ID=1";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;';
echo 'resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function LoadWindow2()
{
URL="/module/user_select_single?ID=2";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth';
echo ':350px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeig';
echo 'ht:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function LoadWindow3()
{
URL="/module/user_select_single?ID=3";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:"+l';
echo 'oc_y+"px;dialogLeft:"+loc_x+"px");
}
</script>
</head>
<body class="bodycolor" topmargin="5" onload="form1.NAME.focus();">
<table border="0" width="90%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img align="absMiddle" src="/images/menu/infofind.gif" width="22" height="20">';
echo '<s';
echo 'pan class="big3"> 工作计划查询</span>
</td>
</tr>
</table>
<table border="0" width="500" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form enctype="multipart/form-data" action="search.php" method="post" name="form1">
<tr>
<td colspan="2" nowrap class="Tableheader">
<img src="/images/green_arrow.gif"> 工作计划查询
</td>
</tr>
';
echo ' <tr>
<td nowrap class="TableContent"> 计划名称：</td>
<td class="TableData">
<input type="text" name="NAME" size="36" maxlength="200" class="BigInput" value="';
echo $NAME;
echo '">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 计划内容：</td>
<td class="TableData">
<input type="text" name="CONTENT" size="36" maxlength="200" class="BigInput" value="';
echo $CONTENT;
echo '">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 有效期：</td>
<td class="TableData">
开始日期：<input type="text" name="BEGIN_DATE" size="10" maxlength="10" class="BigInput" value="';
echo $BEGIN_DATE;
echo '">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.BEGIN_DATE\');"><br>
结束日期：<input type="text" name="END_DATE" size="10" maxlength="10" class="BigInput" value="';
echo $END_DATE;
echo '">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar(\'form1.END_DATE\');">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 计划类型：</td>
<td class="TableData">
';
echo '<s';
echo 'elect name="TYPE" class="BigSelect">
<option value="ALL_TYPE">所有类型</option>
';
$query = 'SELECT * from PLAN_TYPE order by TYPE_NO';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$TYPE_ID = $ROW['TYPE_ID'];
$TYPE_NAME = $ROW['TYPE_NAME'];
echo ' <option value="';
echo $TYPE_ID;
echo '" ';
if (($TYPE == $TYPE_ID))
{
echo 'selected';
}
echo '>';
echo $TYPE_NAME;
echo '</option>
';
}
echo ' </select>
</td>
</tr>
<tr>
<td nowrap class="TableContent">发布范围（部门）：</td>
<td class="TableData">
<input type="hidden" name="TO_ID" value="';
echo $TO_ID;
echo '">
<input type="text" name="TO_NAME" value="';
echo $TO_NAME;
echo '" class=BigStatic size=20 maxlength=100 readonly>
<input type=button value=\'选 择\' class=SmallButton style=height:22px onClick=LoadWindow(\'TO_ID\',\'TO_NAME\') title=选择 name=button>
</td>
</tr>
<tr>
<td nowrap class="TableContent">发布范围（人员）：</td>
<td class="TableData">
<input type="hidden" name="TO_ID3" value="">
<input type="text" name';
echo '="TO_NAME3" size="20" class="BigStatic" readonly>
<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow3()" title="选择发布范围（人员）" name="button">
</td>
</tr>
<tr>
<td nowrap class="TableContent">参与人：</td>
<td class="TableData">
<input type="hidden" name="COPY_TO_ID" value="">
<input type="text" name="COPY_TO_NAME"';
echo ' size="20" class="BigStatic" readonly>
<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow2()" title="选择申请人" name="button">
</td>
</tr>
<tr>
<td nowrap class="TableContent">负责人：</td>
<td class="TableData">
<input type="hidden" name="SECRET_TO_ID" value="">
<input type="text" name="SECRET_TO_NAME" size="20" class=';
echo '"BigStatic" readonly>
<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow1()" title="选择负责人" name="button">
</td>
</tr>
<tr>
<td nowrap class="TableContent"> 备注：</td>
<td class="TableData">
<input type="text" name="REMARK" size="40" maxlength="200" class="BigInput" value="';
echo $REMARK;
echo '">
</td>
</tr>
<tr align="center" class="TableControl">
<td colspan="2" nowrap>
<input type="submit" value="查询" class="BigButton">
</td>
</tr>
</table>
</form>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?