📄 index.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_field.php" );
echo "\r\n<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\r\n<script Language=\"JavaScript\">\r\n\t\r\nfunction add_detail()\r\n{\r\n if (document.form1.PRO_ID.value==\"\")\r\n {\r\n \talert(\"请选择产品!!\");\r\n return;\r\n }\r\n if(CheckForm())\r\n {\r\n document.form1.OP.value=\"1\";\r\n document.form1.submit();\r\n }\r\n}\t\r\nfunction LoadWindow3()\r\n{\r\n URL=\"/module/crm/product_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}\t\r\nfunction CheckForm()\r\n{\r\n\t if(document.form1.PROVIDER_ID.value==\"\")\r\n { alert(\"供应商名称不能为空！\");\r\n return (false);\r\n }\r\n\t \r\n\t if(document.form1.PROVIDER_NAME.value==\"\")\r\n { alert(\"供应商名称不能为空！\");\r\n return (false);\r\n }\r\n \r\n if(document.form1.ORDER_NO.value==\"\")\r\n { alert(\"订单编号不能为空！\");\r\n return (false);\r\n }\r\n\t \r\n if(document.form1.ORDER_NAME.value==\"\")\r\n { alert(\"订单名称不能为空！\");\r\n return (false);\r\n }\r\n return (true);\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\n\r\n function 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\n\r\nfunction LoadWindow2()\r\n{\r\n URL=\"/module/crm/provider_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:325px;dialogHeight:245px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\r\n}\r\n\r\nfunction edit_line(LINE_ID)\r\n{\r\n document.form1.OP.value=\"1\";\r\n document.form1.LINE_ID.value=LINE_ID;\r\n document.form1.submit();\r\n}\t\r\n\r\nfunction delete_line(LINE_ID)\r\n{\r\n msg='确认要删除该明细？';\r\n if(window.confirm(msg))\r\n {\r\n document.form1.OP.value=\"2\";\r\n document.form1.LINE_ID.value=LINE_ID;\r\n document.form1.submit();\r\n }\r\n}\t\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\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\"> ";
if ( $ORDER_ID == "" )
{
echo "新建采购订单";
}
else
{
echo "编辑采购订单";
}
echo "</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n";
if ( $ORDER_ID != "" )
{
$query = "select * from SUPPLY_ORDER where ORDER_ID='".$ORDER_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ORDER_NO1 = $ROW['ORDER_NO'];
$ORDER_NAME1 = $ROW['ORDER_NAME'];
$ORDER_TYPE1 = $ROW['ORDER_TYPE'];
$ORDER_MEMO1 = $ROW['ORDER_MEMO'];
$PROVIDER_ID1 = $ROW['PROVIDER_ID'];
$LINKMAN_ID1 = $ROW['LINKMAN_ID'];
$CREATOR1 = $ROW['CREATOR'];
$RECIVER1 = $ROW['RECIVER'];
$CREATE_DATE1 = $ROW['CREATE_DATE'];
$BEGIN_DATE1 = $ROW['BEGIN_DATE'];
$ORDER_PRINT1 = $ROW['ORDER_PRINT'];
$REMARK1 = $ROW['REMARK'];
$USERDEF11 = $ROW['USERDEF1'];
$USERDEF21 = $ROW['USERDEF2'];
$USERDEF31 = $ROW['USERDEF3'];
$USERDEF41 = $ROW['USERDEF4'];
$USERDEF51 = $ROW['USERDEF5'];
}
$query2 = "select PROVIDER_NAME from PROVIDER where PROVIDER_ID='".$PROVIDER_ID1."'";
$cursor2 = exequery( $connection, $query2 );
if ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$PROVIDER_NAME1 = $ROW['PROVIDER_NAME'];
}
$query2 = "select USER_NAME from USER where USER_ID='".$CREATOR1."'";
$cursor2 = exequery( $connection, $query2 );
if ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$CREATOR_NAME1 = $ROW['USER_NAME'];
}
$query2 = "select USER_NAME from USER where USER_ID='".$RECIVER1."'";
$cursor2 = exequery( $connection, $query2 );
if ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$RECIVER_NAME1 = $ROW['USER_NAME'];
}
}
echo "<table width=\"450\" class=\"tableblock\" align=\"center\" >\r\n <form action=\"add.php\" enctype=\"multipart/form-data\" method=\"post\" name=\"form1\" onSubmit=\"return CheckForm();\">\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=\"PROVIDER_ID\" value=\"";
echo $PROVIDER_ID1;
echo "\">\r\n <input type=\"text\" name=\"PROVIDER_NAME\" class=\"BigStatic\" size=\"15\" maxlength=\"100\" readonly value=\"";
echo $PROVIDER_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=\"ORDER_NO\" class=\"BigInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $ORDER_NO1;
echo "\">\r\n </td>\r\n </tr>\r\n\r\n <tr>\r\n <td nowrap class=\"TableData\">订单类型： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n <select name=\"ORDER_TYPE\" class=\"BigSelect\">\r\n";
getalldate( "ORDER_TYPE", $ORDER_TYPE1 );
echo " </select>\r\n\r\n <a href=\"javascript:LoadWindow1('ORDER_TYPE','ORDER_TYPE');\"><img src=\"/images/edit1.gif\" align=\"absmiddle\" border=0 title=\"订单类型定义\"></a>\r\n\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=\"ORDER_NAME\" class=\"BigInput\" size=\"51\" maxlength=\"100\" value=\"";
echo $ORDER_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=\"ORDER_MEMO\" class=\"BigInput\" wrap=\"yes\">";
echo $ORDER_MEMO1;
echo "</textarea>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">创建日期：</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"CREATE_DATE\" size=\"15\" maxlength=\"10\" class=\"BigStatic\" readonly value=\"";
if ( $ORDER_ID != "" )
{
echo $CREATE_DATE1;
}
else
{
echo $CREATE_DATE = date( "Y-m-d", time( ) );
}
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('form1.CREATE_DATE');\">\r\n </td>\r\n <td nowrap class=\"TableData\">来货日期： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"BEGIN_DATE\" size=\"15\" maxlength=\"10\" class=\"BigStatic\" readonly value=\"";
echo $BEGIN_DATE1;
echo "\">\r\n <img src=\"/images/menu/calendar.gif\" align=\"absMiddle\" border=\"0\" style=\"cursor:hand\" onClick=\"td_calendar('form1.BEGIN_DATE');\"> \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">创建人： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"hidden\" name=\"CREATOR\" value=\"";
echo $LOGIN_USER_ID;
echo "\" >\r\n";
$query2 = "select USER_NAME from USER where USER_ID='".$LOGIN_USER_ID."'";
$cursor2 = exequery( $connection, $query2 );
if ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$SELLER1_NAME = $ROW['USER_NAME'];
}
echo " <input type=\"text\" name=\"CREATOR_NAME\" class=\"BigStatic\" readonly size=\"15\" maxlength=\"100\" value=\"";
echo $SELLER1_NAME;
echo "\">\r\n </td>\r\n <td nowrap class=\"TableData\">负责人： </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"hidden\" name=\"TO_ID\" value=\"";
echo $RECIVER1;
echo "\">\r\n <input type=\"text\" name=\"TO_NAME\" class=\"BigStatic\" readonly size=\"15\" maxlength=\"100\" value=\"";
echo $RECIVER_NAME1;
echo "\">\r\n <input type=\"button\" value=\"选择\" class=\"SmallButton\" onClick=\"SelectUserSingle('','TO_ID', 'TO_NAME')\" title=\"指定负责人\" name=\"button\">\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 <textarea cols=57 rows=3 name=\"REMARK\" class=\"BigInput\" wrap=\"yes\">";
echo $REMARK1;
echo "</textarea>\r\n </td>\r\n</tr>\r\n<tr>\r\n <td class=\"TableData\" colspan=\"4\">\r\n ";
echo get_field_table( get_field_html( "SUPPLY_ORDER", $ORDER_ID ) );
echo " </td>\r\n</tr>\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\" colspan=\"3\">\r\n <input type=\"hidden\" name=\"PRO_ID\" value=\"\">\r\n <input type=\"hidden\" name=\"PRICE\" value=\"\">\r\n <input type=\"text\" name=\"PRO_NAME\" size=\"20\" class=\"BigStatic\" maxlength=\"20\" value=\"\" readonly> \r\n <input type=\"button\" value=\"选 择\" class=\"SmallButton\" onClick=\"LoadWindow3()\" title=\"选择产品\" name=\"button\"> \r\n <input type=\"button\" value=\"添加\" class=\"SmallButton\" title=\"添加\" name=\"button\" onClick=\"add_detail();\"> \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" colspan=\"4\">\r\n \t <table border=\"0\" class=\"TableList\">\r\n \t \t <tr >\r\n \t <td nowrap align=\"center\">产品名称</td>\r\n \t <td nowrap align=\"center\">产品型号</td>\r\n <td nowrap align=\"center\">单价</td>\r\n <td nowrap align=\"center\">交付数量</td>\r\n <td nowrap align=\"center\">总价</td>\r\n <td nowrap align=\"center\">备注</td>\r\n <td nowrap align=\"center\">操作</td>\r\n </tr>\r\n";
$query = "SELECT a.LINE_ID as LINE_ID,b.PRODUCT_ID as PRODUCT_ID,b.PRODUCT_NAME as PRODUCT_NAME,\r\n a.TRANS_PRICE as TRANS_PRICE,\r\n a.TRANS_QTY as TRANS_QTY,a.PAYMENT as PAYMENT,a.MEMO as MEMO,\r\n b.PRODUCT_CODE as PRODUCT_CODE,a.TRANS_PRICE*a.TRANS_QTY as TOTALPRICE\r\n from ORDER_LINE a\r\n LEFT OUTER JOIN PRODUCT b ON a.PRODUCT_ID = b.PRODUCT_ID\r\n where a.ORDER_ID='".$ORDER_ID."' order by a.LINE_ID desc ";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
$SUM_TRANS_QTY = 0;
$SUM_TOTAL_PRICE = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$VOTE_COUNT;
$LINE_ID = $ROW['LINE_ID'];
$PRODUCT_ID = $ROW['PRODUCT_ID'];
$PRODUCT_NAME = $ROW['PRODUCT_NAME'];
$TRANS_PRICE = $ROW['TRANS_PRICE'];
$TRANS_QTY = $ROW['TRANS_QTY'];
$PAYMENT = $ROW['PAYMENT'];
$MEMO = $ROW['MEMO'];
$PRODUCT_CODE = $ROW['PRODUCT_CODE'];
$TOTAL_PRICE = $ROW['TOTALPRICE'];
$SUM_TRANS_QTY += $TRANS_QTY;
$SUM_TOTAL_PRICE += $TOTAL_PRICE;
if ( $VOTE_COUNT % 2 == 1 )
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -