📄 edit.php
字号:
<td nowrap class="TableData">签约人（卖方）： </td>
<td nowrap class="TableData">
<input type="hidden" name="TO_ID" value="<?=$CONTRACT_LINKMAN21?>">
<?
$query2="select USER_NAME from USER where USER_ID='$CONTRACT_LINKMAN21'";
$cursor2 = exequery($connection, $query2);
if($ROW=mysql_fetch_array($cursor2))
$LINKMAN2_NAME=$ROW["USER_NAME"];
?>
<input type="text" name="TO_NAME" class="BigStatic" readonly size="15" maxlength="100" value="<?=$LINKMAN2_NAME?>">
<input type="button" value="选择" class="SmallButton" onClick="LoadWindow()" title="指定签约人" name="button">
</td>
</tr>
<tr>
<td nowrap class="TableData">创建日期： </td>
<td nowrap class="TableData">
<input type="text" name="CREATE_DATE" class="BigStatic" readonly size="15" maxlength="100" value="<?=$CREATE_DATE?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.CREATE_DATE');">
</td>
<td nowrap class="TableData">创建人： </td>
<td nowrap class="TableData">
<input type="hidden" name="SELLER" value="<?=$SELLER1?>" >
<?
$query2="select USER_NAME from USER where USER_ID='$SELLER1'";
$cursor2 = exequery($connection, $query2);
if($ROW=mysql_fetch_array($cursor2))
$SELLER1_NAME=$ROW["USER_NAME"];
?>
<input type="text" name="SELLER_NAME" class="BigStatic" readonly size="15" maxlength="100" value="<?=$SELLER1_NAME?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">合同附件： </td>
<td nowrap class="TableData" colspan="3">
<?
if($ATTACHMENT_NAME=="")
echo "无";
else
{
$ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
$ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);
$ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
for($I=0;$I<$ARRAY_COUNT;$I++)
{
if($ATTACHMENT_ID_ARRAY[$I]=="")
break;
$ATTACH_SIZE=attach_size($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
$ATTACH_SIZE=number_format($ATTACH_SIZE,0, ".",",");
?>
<img src="/images/email_atta.gif" align="absmiddle"><a href="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>" target="_blank"><?=$ATTACHMENT_NAME_ARRAY[$I]?></a>
<?
if(stristr($ATTACHMENT_NAME_ARRAY[$I],".doc")||stristr($ATTACHMENT_NAME_ARRAY[$I],".ppt")||stristr($ATTACHMENT_NAME_ARRAY[$I],".xls"))
{
?>
<input type="button" value="阅读" class="SmallButton" onClick="window.open('/module/OC?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&OP=5','<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">
<input type="button" value="编辑" class="SmallButton" onClick="window.open('/module/OC?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&OP=4','<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">
<?
}
else if(is_media($ATTACHMENT_NAME_ARRAY[$I]))
{
?>
<input type="button" value="播放" class="SmallButton" onClick="window.open('/module/mediaplayer/index.php?MEDIA_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&MEDIA_URL=<?=urlencode("/inc/attach.php?ATTACHMENT_ID=".($ATTACHMENT_ID_ARRAY[$I]*3+2)."&ATTACHMENT_NAME=".urlencode($ATTACHMENT_NAME_ARRAY[$I]))?>','media<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">
<?
}
?>
<input type="button" value="删除" class="SmallButton" onClick="delete_attach('<?=$ATTACHMENT_ID_ARRAY[$I]?>','<?=$ATTACHMENT_NAME_ARRAY[$I]?>');">
(<?=$ATTACH_SIZE?>字节)<br>
<?
}
}
?>
</td>
</tr>
<tr>
<td nowrap class="TableData">附件上传：</td>
<td class="TableData" colspan="3">
<input type="file" name="ATTACHMENT" size="30" class="BigInput" title="选择附件文件">
<input type="button" value="上传附件" class="BigButton" onclick="upload_attach();" title="上传附件">
<input type="hidden" name="ATTACHMENT_ID_OLD" value="<?=$ATTACHMENT_ID?>">
<input type="hidden" name="ATTACHMENT_NAME_OLD" value="<?=$ATTACHMENT_NAME?>">
</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
备注：
</td>
</tr>
<tr>
<td nowrap class="TableData">备注1： </td>
<td nowrap class="TableData" colspan="3">
<textarea cols=55 rows=3 name="MEMO" class="BigInput" wrap="yes"><?=$MEMO?></textarea>
</td>
</tr>
<tr>
<td nowrap class="TableData">备注2： </td>
<td nowrap class="TableData" colspan="3">
<textarea cols=55 rows=3 name="MEMO1" class="BigInput" wrap="yes"><?=$MEMO1?></textarea>
</td>
</tr>
<?
$count=0;
$connection=OpenConnection();
$query = "select count(*) from FIELDSETTING where TABLENAME='CONTRACT'";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$count=$ROW[0];
}
if($count>0)
{
?>
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
用户自定义字段：
</td>
</tr>
<?
$query = "select * from FIELDSETTING where TABLENAME='CONTRACT' ORDER BY ORDERNO ASC ";
$cursor=exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$FIELDNAME=$ROW["FIELDNAME"];
$ORDERNO=$ROW["ORDERNO"];
$STYPE=$ROW["STYPE"];
$TYPENAME=$ROW["TYPENAME"];
$TYPEVALUE=$ROW["TYPEVALUE"];
$TYPECODE=$ROW["TYPECODE"];
$ISQUERY=$ROW["ISQUERY"];
$ISGROUY=$ROW["ISGROUY"];
$FIELDNAME=$ROW["FIELDNAME"];
$FIELDNO=$ROW["FIELDNO"];
$FIELDNO1=$FIELDNO."1";
?>
<tr>
<td nowrap class="TableData"><?=$FIELDNAME?>：</td>
<td nowrap class="TableData" colspan="3">
<?
if($STYPE=="T")
{
?>
<input type="text" name='<?=$FIELDNO?>' class="BigInput" size="33" maxlength="25" value="<?=$$FIELDNO1?>">
<?
}
if($STYPE=="MT")
{
?>
<textarea cols=37 rows=3 name='<?=$FIELDNO?>' class="BigInput" wrap="yes"><?=$$FIELDNO1?></textarea>
<?
}
if($STYPE=="D")
{
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
?>
<select name='<?=$FIELDNO?>' class="BigSelect">
<?
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
?>
<option value="<?=$TYPEVALUE_ARRAY[$I]?>" <?if($$FIELDNO1==$TYPEVALUE_ARRAY[$I]) echo "selected";?>><?=$TYPENAME_ARRAY[$I]?></option>
<?
}
}
if($STYPE=="C")
{
$temp=str_replace("，",",",$$FIELDNO1);
$temp_ARRAY=explode(",",$temp);
$temp_ARRAY_count=sizeof($temp_ARRAY);
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
?>
<input type="hidden" name='<?=$FIELDNO?>' value="<?=$temp?>">
<?
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
$flag=0;
for($T=0;$T< $temp_ARRAY_count;$T++)
{
if($temp_ARRAY[$T]==$TYPEVALUE_ARRAY[$I])$flag=1;
}
?>
<input type="checkbox" name='C<?=$FIELDNO?>' id='C<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>" <? if($flag==1) echo "checked";?> onclick="return chk(this,'C<?=$FIELDNO?>','<?=$FIELDNO?>','<?=$TYPENAME_COUNT?>');"><label for="C<?=$FIELDNO?><?=$I?>"><?=$TYPENAME_ARRAY[$I]?></label>
<?
}
}
if($STYPE=="R")
{
$TYPEVALUE=str_replace("，",",",$TYPEVALUE);
$TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
$TYPENAME=str_replace("，",",",$TYPENAME);
$TYPENAME_ARRAY=explode(",",$TYPENAME);
$TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
?>
<input type="radio" name='<?=$FIELDNO?>' id='<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>" <? if($$FIELDNO1==$TYPEVALUE_ARRAY[$I]) echo "checked";?> ><label for="<?=$FIELDNO?><?=$I?>"><?=$TYPENAME_ARRAY[$I]?></label>
<?
}
}
?>
</td>
</tr>
<?
}
}
?>
<tr>
<td nowrap class="TableControl" colspan="4" align="center">
<?
if($querstr!="")
{
$urlstr1=str_replace("%","&",$querstr);
?>
<input type="hidden" name="OP" value="">
<input type="hidden" name="CONTRACT_ID" value="<?=$CONTRACT_ID?>">
<input type="hidden" name="ATTACHMENT_NAME">
<input type="hidden" name="querstr" value="<?=$querstr?>">
<input type="hidden" value="<?=$querstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>" name="QUERY_LIST">
<input type="hidden" value="ad_query" name="FLAGSOURCE">
<input type="submit" value="确定" class="BigButton" name="button">
<input type="button" value="返回" class="BigButton" onclick="location='ad_query/list.php?<?=$urlstr1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>'">
<?
}
else
{
?>
<input type="hidden" name="OP" value="">
<input type="hidden" value="-1" name="FLAGSOURCE">
<input type="hidden" name="CONTRACT_ID" value="<?=$CONTRACT_ID?>">
<input type="hidden" name="ATTACHMENT_NAME">
<input type="hidden" value="CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&CONTRACT_TYPE=<?=$CONTRACT_TYPE?>&CONTRACT_NO=<?=$CONTRACT_NO?>&CONTRACT_NAME=<?=$CONTRACT_NAME?>&DATE_TYPE=<?=$DATE_TYPE?>&CONTRACT_LINKMAN1=<?=$CONTRACT_LINKMAN1?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CONTRACT_LINKMAN2=<?=$CONTRACT_LINKMAN2?>&SIGN=<?=$SIGN?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>" name="QUERY_LIST">
<input type="submit" value="确定" class="BigButton" name="button">
<input type="button" value="返回" class="BigButton" onclick="location='index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&CONTRACT_TYPE=<?=$CONTRACT_TYPE?>&DATE_TYPE=<?=$DATE_TYPE?>&CONTRACT_NO=<?=$CONTRACT_NO?>&CONTRACT_NAME=<?=$CONTRACT_NAME?>&CONTRACT_LINKMAN1=<?=$CONTRACT_LINKMAN1?>&CONTRACT_LINKMAN2=<?=$CONTRACT_LINKMAN2?>&SIGN=<?=$SIGN?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>'">
<?
}
?>
</td>
</tr>
</form>
</table>
</body>
</html>
<?
function GETALLDATE($CODE,$GETVALUE)
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
$connection=OpenConnection();
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$CODE_NO=$ROW["CODE_NO"];
$CODE_NAME=$ROW["CODE_NAME"];
if ($CODE_NO==$GETVALUE)
{echo "<option value=".$CODE_NO." selected>".$CODE_NAME."</option>";}
else
{echo "<option value=".$CODE_NO." >".$CODE_NAME."</option>";}
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -