📄 edit.php
字号:
<?php
function GETALLDATE( $CODE, $GETVALUE )
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='".$CODE."'";
$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>";
}
}
}
include_once( "inc/auth.php" );
include_once( "inc/utility_file.php" );
include_once( "inc/utility_field.php" );
include_once( "inc/editor.php" );
echo "<html>\r\n<head>\r\n<title>修改合同</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"><script src=\"/inc/js/module.js\"></script>\r\n<script src=\"/inc/js/utility.js\"></script>\r\n<script src=\"/inc/js/attach.js\"></script>\r\n<script Language=\"JavaScript\">\r\nvar upload_limit=";
echo $UPLOAD_LIMIT;
echo ",limit_type=\"";
echo strtolower( $UPLOAD_LIMIT_TYPE );
echo "\";\r\nfunction delete_attach(ATTACHMENT_ID,ATTACHMENT_NAME)\r\n{\r\n msg=\"确定要删除文件 '\"+ ATTACHMENT_NAME +\"' 吗?\";\r\n if(window.confirm(msg))\r\n {\r\n if(document.all(\"FLAGSOURCE\").value==\"ad_query\")\r\n {\r\n \tURL=\"delete_attach.php?CONTRACT_ID=";
echo $CONTRACT_ID;
echo "&ATTACHMENT_ID=\"+ATTACHMENT_ID+\"&ATTACHMENT_NAME=\"+URLSpecialChars(ATTACHMENT_NAME)+\"&querstr=\"+document.all(\"querstr\").value;\r\n }\r\n else\r\n {\r\n \tURL=\"delete_attach.php?CONTRACT_ID=";
echo $CONTRACT_ID;
echo "&ATTACHMENT_ID=\"+ATTACHMENT_ID+\"&ATTACHMENT_NAME=\"+URLSpecialChars(ATTACHMENT_NAME)+\"&CUSTOMER_NAME=";
echo $CUSTOMER_NAME;
echo "&KIND=";
echo $KIND;
echo "&SELLMODE=";
echo $SELLMODE;
echo "&CONTRACT_TYPE=";
echo $CONTRACT_TYPE;
echo "&DATE_TYPE=";
echo $DATE_TYPE;
echo "&CONTRACT_NO=";
echo $CONTRACT_NO;
echo "&CONTRACT_NAME=";
echo $CONTRACT_NAME;
echo "&CONTRACT_LINKMAN1=";
echo $CONTRACT_LINKMAN1;
echo "&CONTRACT_LINKMAN2=";
echo $CONTRACT_LINKMAN2;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\";\r\n }\r\n window.location=URL;\r\n }\r\n}\r\nfunction upload_attach()\r\n{\r\n if (document.form1.ATTACHMENT.value==\"\")\r\n return;\r\n if(CheckForm())\r\n {\r\n document.form1.OP.value=\"1\";\r\n document.form1.submit();\r\n }\r\n}\r\nfunction CheckForm()\r\n{\r\n if(document.form1.CONTRACT_NAME.value==\"\")\r\n { alert(\"合同名称不能为空！\");\r\n return (false);\r\n }\r\n\r\n if(document.form1.BEGIN_DATE.value==\"\")\r\n { alert(\"生效日期不能为空！\");\r\n return (false);\r\n }\r\n\r\n if(document.form1.END_DATE.value==\"\")\r\n { alert(\"终止日期不能为空！\");\r\n return (false);\r\n }\r\n if(!upload_limit(document.form1.ATTACHMENT.value, ";
echo $UPLOAD_LIMIT;
echo ", \"";
echo $UPLOAD_LIMIT_TYPE;
echo "\"))\r\n return false;\r\n return (true);\r\n}\r\nfunction InsertImage(src)\r\n{\r\n TDeditorAPI.GetInstance('CONTRACT_CONTENT').InsertHtml('<img src=\"'+src+'\">');\r\n}\r\n\r\nfunction chk(input,KC,KT,count)\r\n {\r\n var lstr=\"\";\r\n \t if(count==1)\r\n \t {\r\n \t \tif(document.all(KC).checked)\r\n \t \t{\r\n \t \t\tdocument.all(KT).value=document.all(KC).value;\r\n \t \t}\r\n \t else\r\n \t {\r\n \t \tdocument.all(KT).value=\"\";\r\n \t }\r\n\r\n \t }\r\n \telse\r\n \t{\r\n \t for(i=0;i<document.all(KC).length;i++)\r\n {\r\n el=document.all(KC).item(i);\r\n if(el.checked)\r\n {\r\n \t val=el.value;\r\n lstr+=val+\",\";\r\n\r\n }\r\n }\r\n\r\n \tdocument.all(KT).value=lstr;\r\n }\r\n }\r\nfunction checkit(chkbox)\r\n{\r\nif(chkbox.checked)\r\n\tchkbox.value=1\r\nelse \r\n\tchkbox.value=0\r\n}\r\nfunction LoadWindow1(kname,codeid)\r\n{\r\n URL=\"/module/crm/codedefine.php?kname=\"+kname+\"&codeid=\"+codeid;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"formul_edit\",\"height=300,width=550,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\nfunction LoadWindow2()\r\n{\r\n URL=\"/module/crm/customer_select\";\r\n loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;\r\n loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;\r\n window.showModalDialog(URL,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:245px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\r\n}\r\n\r\n</script>\r\n</head>\r\n";
$CREATE_DATE = date( "Y-m-d", time( ) );
if ( $CONTRACT_ID != "" )
{
$query = "select * from CONTRACT where CONTRACT_ID='".$CONTRACT_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$CONTRACT_ID = $ROW['CONTRACT_ID'];
$CONTRACT_NO1 = $ROW['CONTRACT_NO'];
$CONTRACT_NAME1 = $ROW['CONTRACT_NAME'];
$CONTRACT_TYPE1 = $ROW['CONTRACT_TYPE'];
$CONTRACT_ARTICLE = $ROW['CONTRACT_ARTICLE'];
$CONTRACT_CONTENT = $ROW['CONTRACT_CONTENT'];
$CONTRACT_CONTENT = str_replace( "\"", "'", $CONTRACT_CONTENT );
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$CONTRACT_PRINT = $ROW['CONTRACT_PRINT'];
$CONTRACT_MEMO = $ROW['CONTRACT_MEMO'];
$CUSTOMER_ID = $ROW['CUSTOMER_ID'];
$CONTRACT_LINKMAN11 = $ROW['CONTRACT_LINKMAN1'];
$CONTRACT_LINKMAN21 = $ROW['CONTRACT_LINKMAN2'];
$SELLER1 = $ROW['SELLER'];
$CREATE_DATE = $ROW['CREATE_DATE'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$END_DATE = $ROW['END_DATE'];
if ( $END_DATE == "0000-00-00" )
{
$END_DATE = "";
}
if ( $BEGIN_DATE == "0000-00-00" )
{
$BEGIN_DATE = "";
}
if ( $CREATE_DATE == "0000-00-00" )
{
$CREATE_DATE = "";
}
$MEMO = $ROW['MEMO'];
$MEMO1 = $ROW['MEMO1'];
$USERDEF11 = $ROW['USERDEF1'];
$USERDEF21 = $ROW['USERDEF2'];
$USERDEF31 = $ROW['USERDEF3'];
$USERDEF41 = $ROW['USERDEF4'];
$USERDEF51 = $ROW['USERDEF5'];
$REMIND_CONTRACT_STARTTIME = $ROW['REMIND_CONTRACT_STARTTIME'];
$REMIND_CONTRACT_ENDTIME = $ROW['REMIND_CONTRACT_ENDTIME'];
$TOK = strtok( $REMIND_CONTRACT_STARTTIME, "," );
while ( $TOK != "" )
{
$query1 = "SELECT USER_NAME from USER where USER_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$SECRET_TO_NAME .= $ROW['USER_NAME'].",";
}
$TOK = strtok( "," );
}
$TOK = strtok( $REMIND_CONTRACT_ENDTIME, "," );
while ( $TOK != "" )
{
$query1 = "SELECT USER_NAME from USER where USER_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$COPY_TO_NAME .= $ROW['USER_NAME'].",";
}
$TOK = strtok( "," );
}
}
}
$query2 = "select CUSTOMER_NAME from CUSTOMER where CUSTOMER_ID='".$CUSTOMER_ID."'";
$cursor2 = exequery( $connection, $query2 );
if ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$CUSTOMER_NAME1 = $ROW['CUSTOMER_NAME'];
}
echo "<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 编辑合同</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n<form action=\"add.php\" enctype=\"multipart/form-data\" method=\"post\" name=\"form1\" onSubmit=\"return CheckForm();\">\r\n<table width=\"450\" class=\"TableBlock\" align=\"center\">\r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n 合同基本信息：\r\n </td>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableData\">客户名称： </td>\r\n <td class=\"TableData\">\r\n <input type=\"hidden\" name=\"CUSTOMER_ID\" value=\"";
echo $CUSTOMER_ID;
echo "\">\r\n <input type=\"text\" name=\"CUSTOMER_NAME\" class=\"BigStatic\" size=\"15\" maxlength=\"100\" readonly value=\"";
echo $CUSTOMER_NAME1;
echo "\"> \r\n <input type=\"button\" value=\"选 择\" class=\"SmallButton\" onClick=\"LoadWindow2()\" title=\"选择客户\" name=\"button\">\r\n </td>\r\n <td nowrap class=\"TableData\">合同编号： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"CONTRACT_NO\" class=\"BigInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $CONTRACT_NO1;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">合同类型： </td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"CONTRACT_TYPE\" class=\"BigSelect\">\r\n";
getalldate( "CONTRACT_TYPE", $CONTRACT_TYPE1 );
echo " </select>\r\n\r\n <a href=\"javascript:LoadWindow1('CONTRACT_TYPE','CONTRACT_TYPE');\"><img src=\"/images/edit1.gif\" align=\"absmiddle\" border=0 title=\"客户来源定义\"></a>\r\n\r\n </td>\r\n <td nowrap class=\"TableData\">合同打印样式： </td>\r\n <td nowrap class=\"TableData\">\r\n <select name=\"CONTRACT_PRINT\" class=\"BigSelect\">\r\n <option value=01>产品销售合同</option>\r\n <option value=02>售后服务合同</option>\r\n <option value=03>产品升级合同</option>\r\n <option value=04>产品二次开发合同</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">合同名称： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n <input type=\"text\" name=\"CONTRACT_NAME\" class=\"BigInput\" size=\"50\" maxlength=\"100\" value=\"";
echo $CONTRACT_NAME1;
echo "\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">合同描述： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n \t <textarea cols=57 rows=3 name=\"CONTRACT_MEMO\" class=\"BigInput\" wrap=\"yes\">";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -