⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 edit.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_file.php");
include_once("inc/utility_org.php");
?>

<html>
<head>
<title>图书编辑 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><script src="/inc/js/module.js"></script>

<script Language="JavaScript">
function CheckForm()
{
   if(document.form1.BOOK_NAME.value=="")
   {
   	alert("书名不能为空!");
     	return (false);
   }

   if(document.form1.BOOK_NO.value=="")
   { alert("编号不能为空!");
     return (false);
   }
   if(document.form1.AMT.value=="")
   { alert("数量不能为空!");
     return (false);
   }
   if(document.form1.TO_ID.value=="")
   { alert("借阅范围不能为空!");
     return (false);
   }
   
   return (true);   
}
</script>
</head>
<?
 $query = "SELECT * from BOOK_INFO where BOOK_ID='$BOOK_ID'";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
 {
    $BOOK_NAME1=$ROW["BOOK_NAME"];
    $TYPE_ID1=$ROW["TYPE_ID"];
    $AUTHOR1=$ROW["AUTHOR"];
    $ISBN1=$ROW["ISBN"];
    $PUB_HOUSE1=$ROW["PUB_HOUSE"];
    $PUB_DATE1=$ROW["PUB_DATE"];
    $AREA1=$ROW["AREA"];
    $AMT1=$ROW["AMT"];
    $PRICE1=$ROW["PRICE"];
    $BRIEF1=$ROW["BRIEF"];
    $OPEN1=$ROW["OPEN"];
    $LEND1=$ROW["LEND"];
    $BORR_PERSON1=$ROW["BORR_PERSON"];
    $MEMO1=$ROW["MEMO"];
    $DEPT1=$ROW["DEPT"];
    $BOOK_NO=$ROW["BOOK_NO"];
    $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
    $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
    
 }
 
$query="select DEPT_ID,DEPT_NAME from DEPARTMENT";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
    $DEPT_ID=$ROW["DEPT_ID"];
    $DEPT_NAME=$ROW["DEPT_NAME"];
    if(find_id($OPEN1,$DEPT_ID) && strpos($OPEN1,","))
       $TO_NAME.=$DEPT_NAME.",";
}
if($OPEN1=="ALL_DEPT")
   $TO_NAME="全体部门";
?>

<body class="bodycolor" topmargin="5" onLoad="document.form1.BOOK_NAME.focus();">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/edit.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 图书信息编辑 </span>
    </td>
  </tr>
</table>

<table class="TableBlock"  width="80%"  align="center" >
  <form enctype="multipart/form-data" action="update.php"  method="post" name="form1" onSubmit="return CheckForm();">
   <tr>
    <td nowrap class="TableData">部门:</td>
    <td nowrap class="TableData">
        <select name="DEPT_ID" class="BigSelect">
<?
      echo my_dept_tree(0,$DEPT1,0);
?>
        </select>
    </td>
    <td nowrap class="TableData" rowspan="6" width="150">
<?
   $MODULE=attach_sub_dir();
   $ATTACHMENT_ID1=$ATTACHMENT_ID;
   $YM=substr($ATTACHMENT_ID1,0,strpos($ATTACHMENT_ID1,"_"));
   if($YM)
      $ATTACHMENT_ID1=substr($ATTACHMENT_ID1,strpos($ATTACHMENT_ID,"_")+1);
   $ATTACHMENT_ID_ENCODED=attach_id_encode($ATTACHMENT_ID1,$ATTACHMENT_NAME); 
      
   if($ATTACHMENT_NAME=="")
      echo "<center>暂无封面</center>";
   else
   {
?>
       <a href="/inc/attach.php?MODULE=<?=$MODULE?>&YM=<?=$YM?>&ATTACHMENT_ID=<?=$ATTACHMENT_ID_ENCODED?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME)?>&DIRECT_VIEW=1?>" title="点击查看放大图片" target="_blank"><img src="/inc/attach.php?MODULE=<?=$MODULE?>&YM=<?=$YM?>&ATTACHMENT_ID=<?=$ATTACHMENT_ID_ENCODED?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME)?>"  width='150' border=1 alt="文件名:<?=$ATTACHMENT_NAME?>"></a>	
<?
}
?>    	
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">书名:</td>
    <td nowrap class="TableData">
        <input type="text" name="BOOK_NAME" class="BigInput" size="33" maxlength="100" value="<?=$BOOK_NAME1?>">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">编号:</td>
    <td nowrap class="TableData">
        <input type="text" name="BOOK_NO" class="BigInput" size="33" maxlength="100" value="<?=$BOOK_NO?>">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">图书类别:</td>
    <td nowrap class="TableData">
        <select name="TYPE_ID" class="BigSelect">
<?
      $query = "SELECT * from BOOK_TYPE order by TYPE_ID";
      $cursor= exequery($connection,$query);
      while($ROW=mysql_fetch_array($cursor))
      {
         $TYPE_ID2=$ROW["TYPE_ID"];
         $TYPE_NAME=$ROW["TYPE_NAME"];

?>
          <option value="<?=$TYPE_ID2?>" <? if($TYPE_ID2==$TYPE_ID1) echo "selected";?>><?=$TYPE_NAME?></option>
<?
      }
?>
        </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">作者:</td>
    <td nowrap class="TableData">
        <input type="text" name="AUTHOR" class="BigInput" size="33" maxlength="100" value="<?=$AUTHOR1?>">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">ISBN号:</td>
    <td nowrap class="TableData">
        <input type="text" name="ISBN" class="BigInput" size="33" maxlength="100" value="<?=$ISBN1?>">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">出版社:</td>
    <td nowrap class="TableData" colspan="2">
        <input type="text" name="PUB_HOUSE" class="BigInput" size="33" maxlength="100" value="<?=$PUB_HOUSE1?>">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">出版日期:</td>
    <td nowrap class="TableData" colspan="2">
        <input type="text" name="PUB_DATE" class="BigInput" size="30" maxlength="10" value="<?=$PUB_DATE1?>">&nbsp;
        <img src="/images/menu/calendar.gif" align="absMiddle" border="0" style="cursor:hand" onClick="td_calendar('form1.PUB_DATE');">
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">存放地点:</td>
    <td nowrap class="TableData" colspan="2">
        <input type="text" name="AREA" class="BigInput" size="33" maxlength="100" value="<?=$AREA1?>">&nbsp
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">数量:</td>
    <td nowrap class="TableData" colspan="2">
        <input type="text" name="AMT" class="BigInput" size="25" maxlength="11" value="<?=$AMT1?>">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">价格:</td>
    <td nowrap class="TableData" colspan="2">
        <input type="text" name="PRICE" class="BigInput" size="25" maxlength="10" value="<?=$PRICE1?>">&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">内容简介:</td>
    <td nowrap class="TableData" colspan="2">
      	<textarea cols=37 rows=3 name="BRIEF" class="BigInput" wrap="yes"><?=$BRIEF1?></textarea>
    </td>
   </tr>
   <tr>
     <td nowrap class="TableData">借阅范围:</td>
     <td class="TableData" colspan="2">
       <input type="hidden" name="TO_ID" value="<?=$OPEN1?>">
       <textarea cols=30 name=TO_NAME rows=2 class="BigStatic" wrap="yes" readonly><?=$TO_NAME?></textarea>
       <a href="javascript:;" class="orgAdd" onClick="SelectDept()">添加</a>
       <a href="javascript:;" class="orgClear" onClick="ClearUser()">清空</a>
     </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">借阅状态:</td>
    <td nowrap class="TableData" colspan="2">
      <select name="LEND" class="BigSelect">
        <option value="0" <?if($LEND1=="0") echo "selected";?>>未借出 </option>
        <option value="1" <?if($LEND1=="1") echo "selected";?>>已借出 </option>
      </select>
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">录入人:</td>
    <td nowrap class="TableData" colspan="2">
        <input type="text" name="BORR_PERSON" class="BigStatic" size="33" maxlength="100" value="<?=$BORR_PERSON1?>" readonly>&nbsp;
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData" width="120">备注:</td>
    <td nowrap class="TableData" colspan="2">
        <input type="text" name="MEMO" class="BigInput" size="33" maxlength="100" value="<?=$MEMO1?>">&nbsp;
    </td>
   </tr> 
   <tr>
     <td nowrap class="TableData"><span id="ATTACH_LABEL">上传封面:</span></td>
     <td class="TableData" colspan="2">
       <input type="file" name="ATTACHMENT" size="40" class="BigInput" title="选择附件文件">
     </td>
   </tr>
   <tr>
    <td nowrap  class="TableControl" colspan="3" align="center">
        <input type="hidden" value="<?=$BOOK_ID?>" name="BOOK_ID">
        <input type="hidden" value="<?=$ATTACHMENT_ID?>" name="ATTACHMENT_ID_OLD">
        <input type="hidden" value="<?=$ATTACHMENT_NAME?>" name="ATTACHMENT_NAME_OLD">        
        <input type="hidden" value="TYPE_ID=<?=$TYPE_ID?>&BOOK_NAME=<?=$BOOK_NAME?>&AUTHOR=<?=$AUTHOR?>&ISBN=<?=$ISBN?>&PUB_HOUSE=<?=$PUB_HOUSE?>&AREA=<?=$AREA?>&DEPT_ID=<?=$DEPT_ID?>&ORDER_FIELD=<?=$ORDER_FIELD?>&PAGE_START=<?=$PAGE_START?>" name="QUERY_LIST">
        <input type="submit" value="确定" class="BigButton">&nbsp;&nbsp;
        <input type="button" value="返回" class="BigButton" onClick="location='list.php?TYPE_ID=<?=$TYPE_ID?>&BOOK_NAME=<?=$BOOK_NAME?>&AUTHOR=<?=$AUTHOR?>&ISBN=<?=$ISBN?>&PUB_HOUSE=<?=$PUB_HOUSE?>&AREA=<?=$AREA?>&DEPT_ID=<?=$DEPT_ID?>&ORDER_FIELD=<?=$ORDER_FIELD?>&PAGE_START=<?=$PAGE_START?>'">
    </td>
  </form>
</table>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -