📄 formula_edit.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
if ( $ITEM_ID != "" )
{
$query = "SELECT * from SAL_ITEM where ITEM_ID='{$ITEM_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ITEM_ID = $ROW['ITEM_ID'];
$ITEM_NAME = $ROW['ITEM_NAME'];
$FORMULA = $ROW['FORMULA'];
$FORMULANAME = $ROW['FORMULANAME'];
}
}
if ( $FLAG == "1" )
{
$query = "update SAL_ITEM set FORMULANAME='{$textFormula}',FORMULA='{$FormulaID}' where ITEM_ID='{$ITEM_ID}'";
exequery( $connection, $query );
echo " ";
echo "<s";
echo "cript language=javascript>\r\n \twindow.close();\r\n </script>\r\n";
}
echo "<HTML>\r\n<HEAD>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<TITLE>公式编辑</TITLE>\r\n\r\n";
echo "<s";
echo "cript language=\"javascript\">\r\nvar parent_window =window.opener;\r\n//存储光标的位置\r\nfunction storeCaret (textEl)\r\n{\r\n if (textEl.createTextRange)\r\n textEl.caretPos = document.selection.createRange().duplicate();\r\n}\r\n\r\n//将LIST内容插入到光标指定位置\r\nfunction insertAtCaret (textEl, text)\r\n{\r\n\r\n if (textEl.createTextRange && textEl.caretPos)\r\n {\r\n var caretPos = textEl.caretPos";
echo ";\r\n caretPos.text = text;//caretPos.text.charAt(caretPos.text.length - 1) == ' ' ? text + ' ' : text;\r\n }\r\n else\r\n {\r\n textEl.value += text;\r\n }\r\n\r\n textEl.focus();\r\n}\r\n\r\n//编辑公式\r\nfunction funEditFormula ()\r\n{\r\n if (document.formMain.selectList.selectedIndex < 0)\r\n return;\r\n\r\n var strValue = document.formMain.selectList.item(document.formMain.selectList.";
echo "selectedIndex).value;\r\n var aryData = strValue.split (\";\");\r\n\r\n if (aryData [2] == \"IN\")\r\n {\r\n alert (\"您所选择的字段是输入项，不是公式，不能编辑！\");\r\n document.formMain.selectList.focus ();\r\n return;\r\n }\r\n\r\n if (!confirm (\"确定要编辑该公式吗？\"))\r\n return;\r\n\r\n var strFormulaCont = \"\";\r\n for (i = 0; i < aryDataFormula.length; i ++)\r\n {\r\n i";
echo "f (aryDataFormula [i][\"PAYPROID\"] == aryData [0])\r\n {\r\n strFormulaCont = aryDataFormula [i][\"CONTENT\"];\r\n break;\r\n }\r\n }\r\n\r\n document.formMain.textFormula.value = strFormulaCont;\r\n document.formMain.btnFormulaID.value = aryData [0];\r\n document.formMain.btnFormulaName.value = document.formMain.selectList.item(document.formMain.selectList.selectedIndex";
echo ").text;\r\n\r\n document.formMain.FormulaName.value = \"公式编辑：\" + document.formMain.btnFormulaName.value + \"\";\r\n}\r\n\r\n//公式校验\r\nfunction funCheck ()\r\n{\r\n if (document.formMain.textFormula.value == \"\")\r\n {\r\n alert (\"请输入公式内容！\");\r\n document.formMain.textFormula.focus ();\r\n return;\r\n }\r\n reVal = /([^<\\(\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})(\\[|\\(|<)/;\r\n\r\n if (reVal.test(do";
echo "cument.formMain.textFormula.value))\r\n {\r\n //alert (RegExp.\$1 +\"1\\n\"+RegExp.\$2);\r\n alert (\"公式不正确，请检查括号及+-*/是否匹配！\");\r\n return;\r\n }\r\n reVal = /(\\]|\\)|>)([^>\\)\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})/;\r\n\r\n if (reVal.test(document.formMain.textFormula.value))\r\n {\r\n //alert (RegExp.\$1 +\"2\\n\"+RegExp.\$2);\r\n alert (\"公式不正确，请检查括号及+-*/是否匹配！\"";
echo ");\r\n return;\r\n }\r\n\r\n //reVal = /(([^\\(\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})(\\[|\\())|((\\]|\\))([^\\)\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,}))/;\r\n //if (reVal.test(document.formMain.textFormula.value))\r\n //{\r\n // alert (\"公式不正确，请检查括号及+-*/是否匹配！\");\r\n // return;\r\n //}\r\n\r\n}\r\n\r\n//公式保存\r\nfunction SaveInfo ()\r\n{\r\n if (document.formMain.textFormula.value == \"\")\r\n {\r\n ale";
echo "rt (\"请输入公式内容！\");\r\n document.formMain.textFormula.focus ();\r\n return;\r\n }\r\n\r\n reVal = /([^<\\(\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})(\\[|\\(|<)/;\r\n if (reVal.test(document.formMain.textFormula.value))\r\n {\r\n //alert (RegExp.\$1 +\"1\\n\"+RegExp.\$2);\r\n\r\n alert (\"公式不正确，请检查括号及+-*/是否匹配！\");\r\n return;\r\n }\r\n reVal = /(\\]|\\)|>)([^>\\)\\+\\-\\*\\/]|[\\+\\-\\*\\/";
echo "]{2,})/;\r\n if (reVal.test(document.formMain.textFormula.value))\r\n {\r\n //alert (RegExp.\$1 +\"2\\n\"+RegExp.\$2);\r\n alert (\"公式不正确，请检查括号及+-*/是否匹配！\");\r\n return;\r\n }\r\n\r\n var s1=document.formMain.textFormula.value;\r\n\t var re;\r\n //alert(s1);\r\n re=/\\[([^\$,\\]])*/gi;\r\n var r=s1.replace(re, \"[\");\r\n //alert(r);\r\n parent_window.form1.FORMULA.value=r;\r\n ";
echo " parent_window.form1.FORMULANAME.value=document.formMain.textFormula.value;\r\n parent.close();\r\n}\r\n\r\nfunction UpdateInfo(ITEM_ID)\r\n{\r\n if (document.formMain.textFormula.value == \"\")\r\n {\r\n alert (\"请输入公式内容！\");\r\n document.formMain.textFormula.focus ();\r\n return;\r\n }\r\n\r\n reVal = /([^<\\(\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})(\\[|\\(|<)/;\r\n if (reVal.test(document.formMain.te";
echo "xtFormula.value))\r\n {\r\n //alert (RegExp.\$1 +\"1\\n\"+RegExp.\$2);\r\n\r\n alert (\"公式不正确，请检查括号及+-*/是否匹配！\");\r\n return;\r\n }\r\n reVal = /(\\]|\\)|>)([^>\\)\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})/;\r\n if (reVal.test(document.formMain.textFormula.value))\r\n {\r\n //alert (RegExp.\$1 +\"2\\n\"+RegExp.\$2);\r\n alert (\"公式不正确，请检查括号及+-*/是否匹配！\");\r\n return";
echo ";\r\n }\r\n\r\n var s1=document.formMain.textFormula.value;\r\n\t var re;\r\n\r\n re=/\\[([^\$,\\]])*/gi;\r\n var r=s1.replace(re, \"[\");\r\n\r\n document.formMain.FormulaID.value=r;\r\n\r\n formMain.submit();\r\n\r\n}\r\n\r\n</script>\r\n\r\n</HEAD>\r\n\r\n<BODY class=\"panel\">\r\n\r\n<form method=\"POST\" action=\"formula_edit.php?ITEM_ID=";
echo $ITEM_ID;
echo "&FLAG=1\" name=\"formMain\" >\r\n<input type=\"hidden\" name=\"FormulaID\" value=\"";
echo $FORMULA;
echo "\">\r\n\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" class=\"small\">\r\n <tr>\r\n <td colspan=\"5\">\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"500\">\r\n <tr class=\"TableHeader\">\r\n <td align=\"left\">\r\n \t \r\n";
if ( $ITEM_ID == "" )
{
echo " ";
echo "<s";
echo "cript language=\"javascript\">\r\n \tif(parent_window.form1.ITEM_NAME.value!=\"\")\r\n \tdocument.write(parent_window.form1.ITEM_NAME.value+\"=\")\r\n\r\n </script>\r\n";
}
else
{
echo $ITEM_NAME."=";
}
echo " </td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n <td>\r\n <textarea name=\"textFormula\" cols=\"80\" rows=\"5\" class=\"formclass\" onSelect=\"storeCaret(this);\" onClick=\"storeCaret(this);\" onKeyup=\"storeCaret(this);\">";
echo $FORMULANAME;
echo "</textarea>\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width=\"53%\" colspan=\"5\">\r\n \t<br><b>可选字段</b></td>\r\n </tr>\r\n <tr>\r\n <td width=\"12%\">\r\n ";
echo "<s";
echo "elect name=\"selectList\" size=\"10\" onchange=\"insertAtCaret(document.formMain.textFormula, '[' + document.formMain.selectList.item(document.formMain.selectList.selectedIndex).text+'\$'+document.formMain.selectList.item(document.formMain.selectList.selectedIndex).value + ']');\">\r\n";
$query = "SELECT * from SAL_ITEM";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$VOTE_COUNT;
$ITEMID = $ROW['ITEM_ID'];
$ITEMNAME = $ROW['ITEM_NAME'];
echo " <option value=\"";
echo $ITEMID;
echo "\">";
echo $ITEMNAME;
echo "</option>\r\n";
}
echo " </select>\r\n </td>\r\n <td width=\"16%\">\r\n <table width=\"159\">\r\n <tr valign=\"middle\">\r\n <td width=\"35\" >\r\n <input type=\"button\" name=\"btnAdd\" value=\" 1 \" class=\"formclass_show4\" onClick=\"insertAtCaret(document.formMain.textFormula, '1');\">\r\n </td>\r\n <td width=\"35\" >\r\n <input type=\"button\" name=\"btnDec\" value=\" 2 \" c";
echo "lass=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '2');\">\r\n </td>\r\n <td width=\"35\" >\r\n <input type=\"button\" name=\"btnMul\" value=\" 3 \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '3');\">\r\n </td>\r\n <td width=\"36\" >\r\n <input type=\"button\" name=\"btnAdd\" value=\" + \" class=\"formcl";
echo "ass_show4\" onClick=\"insertAtCaret(document.formMain.textFormula, '+');\">\r\n </td>\r\n </tr>\r\n <tr valign=\"middle\">\r\n <td width=\"35\" >\r\n <input type=\"button\" name=\"btnAdd\" value=\" 4 \" class=\"formclass_show4\" onClick=\"insertAtCaret(document.formMain.textFormula, '4');\">\r\n </td>\r\n <td width=\"35\" >\r\n <input type=\"button\" na";
echo "me=\"btnDec\" value=\" 5 \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '5');\">\r\n </td>\r\n <td width=\"35\" >\r\n <input type=\"button\" name=\"btnMul\" value=\" 6 \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '6');\">\r\n </td>\r\n <td width=\"36\" >\r\n <input type=\"button\" name=\"btnDec\"";
echo " value=\" - \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '-');\">\r\n </td>\r\n </tr>\r\n\r\n <tr valign=\"middle\">\r\n <td width=\"35\" >\r\n <input type=\"button\" name=\"btnAdd\" value=\" 7 \" class=\"formclass_show4\" onClick=\"insertAtCaret(document.formMain.textFormula, '7');\">\r\n </td>\r\n <td width=\"35\" >\r\n ";
echo " <input type=\"button\" name=\"btnDec\" value=\" 8 \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '8');\">\r\n </td>\r\n <td width=\"35\" >\r\n <input type=\"button\" name=\"btnMul\" value=\" 9 \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '9');\">\r\n </td>\r\n <td width=\"36\" >\r\n <input t";
echo "ype=\"button\" name=\"btnMul\" value=\" * \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '*');\">\r\n </td>\r\n </tr>\r\n\r\n <tr valign=\"middle\">\r\n \t <td width=\"35\" >\r\n <input type=\"button\" name=\"btnDiv\" value=\" 0 \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '0');\">\r\n </td>\r\n ";
echo "<td width=\"35\" >\r\n <input type=\"button\" name=\"btnDiv\" value=\" . \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '.');\">\r\n </td>\r\n <td width=\"35\" >\r\n <input type=\"button\" name=\"btnLeft\" value=\" = \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '=');\">\r\n </td>\r\n <td width=\"";
echo "36\" >\r\n <input type=\"button\" name=\"btnDiv\" value=\" / \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '/');\">\r\n </td>\r\n\r\n </tr>\r\n <tr valign=\"middle\">\r\n <td width=\"35\" >\r\n <input type=\"button\" name=\"btnLeft\" value=\" < \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '<');\">\r\n ";
echo " </td>\r\n <td width=\"35\">\r\n <input type=\"button\" name=\"btnRight\" value=\" > \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '>');\">\r\n </td>\r\n <td width=\"35\" >\r\n <input type=\"button\" name=\"btnLeft\" value=\" ( \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, '(');\">\r\n </";
echo "td>\r\n <td width=\"36\">\r\n <input type=\"button\" name=\"btnRight\" value=\" ) \" class=\"formclass_show4\" onclick=\"insertAtCaret(document.formMain.textFormula, ')');\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"2\">\r\n <input type=\"button\" name=\"btnCheck\" value=\" 校验 \" class=\"formclass_show4\" onClick=\"funCheck ()\">\r\n\r\n </td>\r\n ";
echo " <td colspan=\"2\">\r\n \r\n";
if ( $ITEM_ID == "" )
{
echo " <input type=\"button\" name=\"btnCheck\" value=\" 确定 \" class=\"formclass_show4\" onClick=\"SaveInfo()\">\r\n";
}
else
{
echo " <input type=\"submit\" value=\" 修改 \" class=\"formclass_show4\" name=\"button\" onClick=\"UpdateInfo('";
echo $ITEM_ID;
echo "')\">\r\n";
}
echo " </td>\r\n </tr>\r\n </table>\r\n </td>\r\n <td width=\"1%\" > </td>\r\n <td width=\"24%\" >";
message( "说明", "个人所得税的输入为<参与所得税计算的工资项目>-个税起征额。例如'<[应发工资]>-800'(表示的是[应发工资]参与所得税计算)或是<[标准工资]+[奖金]>-800(表示的是[标准工资]与[奖金]之和参与所得税计算" );
echo "</td>\r\n </tr>\r\n </table>\r\n</form>\r\n\r\n</BODY>\r\n</HTML>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -