new.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 294 行
PHP
294 行
<?
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 CheckForm()
{
if(document.form1.FIELDNAME.value=="")
{ alert("字段名称不能为空！");
return (false);
}
if(document.form1.ORDERNO.value=="")
{ alert("排序号不能为空！");
return (false);
}
if(document.form1.STYPE.value=="D" || document.form1.STYPE.value=="R" || document.form1.STYPE.value=="C")
{
if(do';
echo 'cument.form1.TYPECODE.value=="" && (document.form1.TYPENAME.value=="" || document.form1.TYPEVALUE.value==""))
{
alert("选项不能为空！");
return (false);
}
}
}
function SelChange()
{
if(document.form1.STYPE.value=="T" || document.form1.STYPE.value=="MT" || document.form1.STYPE.value=="")
{
document.getElementById("select_option").style.display="no';
echo 'ne";
document.getElementById("code_list").style.display="none";
document.getElementById("code_def").style.display="none";
}
else
{
document.getElementById("select_option").style.display="";
if(document.getElementById("CODE_TYPE1").checked)
SelCode(1);
if(document.getElementById("CODE_TYPE2").checked)
SelCode(2);
}
}
f';
echo 'unction SelCode(val)
{
if(val==1)
{
document.getElementById("code_list").style.display="";
document.getElementById("code_def").style.display="none";
}
else if(val==2)
{
document.getElementById("code_list").style.display="none";
document.getElementById("code_def").style.display="";
}
form1.CODE_TYPE.value=val;
}
</script>
</head>
<body cla';
echo 'ss="bodycolor" topmargin="5" onload="document.form1.FIELDNAME.focus();">
';
$query = (((''.'SELECT * from SYS_CODE where CODE_NO=\'').$TABLENAME).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$CODE_NAME = $ROW['CODE_NAME'];
}
if (($FIELDNO != ''))
{
$query = (((((''.'SELECT * from FIELDSETTING where TABLENAME=\'').$TABLENAME).'\' and FIELDNO=\'').$FIELDNO).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$FIELDNO = $ROW['FIELDNO'];
$FIELDNAME = $ROW['FIELDNAME'];
$ORDERNO = $ROW['ORDERNO'];
$STYPE = $ROW['STYPE'];
$TYPECODE = $ROW['TYPECODE'];
$TYPENAME = $ROW['TYPENAME'];
$TYPEVALUE = $ROW['TYPEVALUE'];
$ISQUERY = $ROW['ISQUERY'];
if (($TYPECODE != ''))
{
$CODE_TYPE = 1;
}
else
{
if ((($TYPENAME != '') AND ($TYPECODE == '')))
{
$CODE_TYPE = 2;
}
}
}
}
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 增加自定义字段 — ';
echo $CODE_NAME;
echo '</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="90%" class="small" bgcolor="#000000" cellpadding="3" align="center" >
<form action="insert.php" method="post" name="form1" onsubmit="return CheckForm();">
<tr class="TableData">
<td width="80">字段名称：</td>
<td>
<input type="text" name="FIELDNAME" class="BigInput" size="20" maxlength="100" valu';
echo 'e="';
echo $FIELDNAME;
echo '">
</td>
</tr>
<tr class="TableData">
<td>排 序 号：</td>
<td>
<input type="text" name="ORDERNO" class="BigInput" size="12" maxlength="20" value="';
echo $ORDERNO;
echo '">
</td>
</tr>
<tr class="TableData">
<td>字段类型：</td>
<td>
';
echo '<s';
echo 'elect name="STYPE" class="BigSelect" onchange="SelChange();">
<option value="T"';
if (($STYPE == 'T'))
{
echo ' selected';
}
echo '>单行输入框</option>
<option value="MT"';
if (($STYPE == 'MT'))
{
echo ' selected';
}
echo '>多行输入框</option>
<option value="D"';
if (($STYPE == 'D'))
{
echo ' selected';
}
echo '>下拉菜单</option>
<option value="R"';
if (($STYPE == 'R'))
{
echo ' selected';
}
echo '>单选框</option>
<option value="C"';
if (($STYPE == 'C'))
{
echo ' selected';
}
echo '>复选框</option>
</select>
</td>
</tr>
<tr class="TableData" id="select_option" style="display:';
if (((($STYPE == 'T') OR ($STYPE == 'MT')) OR ($STYPE == '')))
{
echo 'none';
}
else
{
echo '';
}
echo ';">
<td>代码类型：</td>
<td>
<input type="radio" name="radio" id="CODE_TYPE1"';
if (($TYPECODE != ''))
{
echo ' checked';
}
echo ' onclick="SelCode(1);"><label for="CODE_TYPE1">系统代码</label>
<input type="radio" name="radio" id="CODE_TYPE2"';
if ((($TYPENAME != '') AND ($TYPECODE == '')))
{
echo ' checked';
}
echo ' onclick="SelCode(2);"><label for="CODE_TYPE2">自定义选项</label>
</td>
</tr>
<tr class="TableData" id="code_list" style="display:';
if ((((($STYPE == 'D') OR ($STYPE == 'R')) OR ($STYPE == 'C')) AND ($TYPECODE != '')))
{
echo '';
}
else
{
echo 'none';
}
echo ';">
<td>系统代码：</td>
<td>
';
echo '<s';
echo 'elect class="BigSelect" name="TYPECODE">
<option value=""></option>
';
$query = 'SELECT * from SYS_CODE where PARENT_NO=\'\' order by CODE_ORDER';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$CODE_ID = $ROW['CODE_ID'];
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
if (($CODE_NO == $TYPECODE))
{
$SELECTED = 'selected';
}
else
{
$SELECTED = '';
}
echo ((((((' <option value="'.$CODE_NO).'" ').$SELECTED).'>').$CODE_NAME).'</option>
');
}
echo ' </select>
</td>
</tr>
<tbody id="code_def" style="display:';
if (((((($STYPE == 'D') OR ($STYPE == 'R')) OR ($STYPE == 'C')) AND ($TYPENAME != '')) AND ($TYPECODE == '')))
{
echo '';
}
else
{
echo 'none';
}
echo ';">
<tr class="TableData">
<td>选项名称：</td>
<td>
<textarea name="TYPENAME" cols="45" rows="3">';
echo $TYPENAME;
echo '</textarea>
<br>显示的选项，用中文或西文逗号隔开如:（选项1,选项2,选项3）</font>
</td>
</tr>
<tr class="TableData">
<td>选项的值：</td>
<td>
<textarea name="TYPEVALUE" cols="45" rows="3">';
echo $TYPEVALUE;
echo '</textarea>
<br>选项对应存储的值，非重复的数字，用逗号隔开如:（1,2,3）
</td>
</tr>
</tbody>
<tr class="TableData">
<td>字段选项：</td>
<td>
<input type="checkbox" name="ISQUERY" id="ISQUERY"';
if (($ISQUERY == '1'))
{
echo ' checked';
}
echo '><label for="ISQUERY">做为查询字段</label>
</td>
</tr>
<tr class="TableControl">
<td nowrap colspan="2" align="center">
<input type="hidden" name="TABLENAME" value="';
echo $TABLENAME;
echo '">
<input type="hidden" name="FIELDNO" value="';
echo $FIELDNO;
echo '">
<input type="hidden" name="CODE_TYPE" value="';
echo $CODE_TYPE;
echo '">
<input type="submit" value="确定" class="BigButton">
<input type="button" value="返回" class="BigButton" onclick="history.back();">
</td>
</form>
</table>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?