formula_edit.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 385 行

PHP
385 行
字号 
<?
  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>
  	window.close();
  </script>
';
  }
  echo '<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TITLE>公式编辑</TITLE>
';
  echo '<s';
  echo 'cript language="javascript">
var parent_window =window.opener;
//存储光标的位置
function storeCaret (textEl)
{
    if (textEl.createTextRange)
        textEl.caretPos = document.selection.createRange().duplicate();
}
//将LIST内容插入到光标指定位置
function insertAtCaret (textEl, text)
{
    if (textEl.createTextRange && textEl.caretPos)
    {
        var caretPos = textEl.caretPos';
  echo ';
        caretPos.text = text;//caretPos.text.charAt(caretPos.text.length - 1) == \' \' ? text + \' \' : text;
    }
    else
    {
        textEl.value += text;
    }
    textEl.focus();
}
//编辑公式
function funEditFormula ()
{
    if (document.formMain.selectList.selectedIndex < 0)
        return;
    var strValue = document.formMain.selectList.item(document.formMain.selectList.';
  echo 'selectedIndex).value;
    var aryData = strValue.split (";");
    if (aryData [2] == "IN")
    {
        alert ("您所选择的字段是输入项，不是公式，不能编辑！");
        document.formMain.selectList.focus ();
        return;
    }
    if (!confirm ("确定要编辑该公式吗？"))
        return;
    var strFormulaCont = "";
    for (i = 0; i < aryDataFormula.length; i ++)
    {
        i';
  echo 'f (aryDataFormula [i]["PAYPROID"] == aryData [0])
        {
            strFormulaCont = aryDataFormula [i]["CONTENT"];
            break;
        }
    }
    document.formMain.textFormula.value = strFormulaCont;
    document.formMain.btnFormulaID.value = aryData [0];
    document.formMain.btnFormulaName.value = document.formMain.selectList.item(document.formMain.selectList.selectedIndex';
  echo ').text;
    document.formMain.FormulaName.value = "公式编辑：" + document.formMain.btnFormulaName.value + "";
}
//公式校验
function funCheck ()
{
    if (document.formMain.textFormula.value == "")
    {
        alert ("请输入公式内容！");
        document.formMain.textFormula.focus ();
        return;
    }
 reVal = /([^<\\(\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})(\\[|\\(|<)/;
    if (reVal.test(do';
  echo 'cument.formMain.textFormula.value))
    {
        //alert (RegExp.$1 +"1\\n"+RegExp.$2);
        alert ("公式不正确，请检查括号及+-*/是否匹配！");
        return;
    }
    reVal = /(\\]|\\)|>)([^>\\)\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})/;
    if (reVal.test(document.formMain.textFormula.value))
    {
        //alert (RegExp.$1 +"2\\n"+RegExp.$2);
        alert ("公式不正确，请检查括号及+-*/是否匹配！"';
  echo ');
        return;
    }
    //reVal = /(([^\\(\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})(\\[|\\())|((\\]|\\))([^\\)\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,}))/;
    //if (reVal.test(document.formMain.textFormula.value))
    //{
    //    alert ("公式不正确，请检查括号及+-*/是否匹配！");
    //    return;
    //}
}
//公式保存
function SaveInfo ()
{
    if (document.formMain.textFormula.value == "")
    {
        ale';
  echo 'rt ("请输入公式内容！");
        document.formMain.textFormula.focus ();
        return;
    }
    reVal = /([^<\\(\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})(\\[|\\(|<)/;
    if (reVal.test(document.formMain.textFormula.value))
    {
        //alert (RegExp.$1 +"1\\n"+RegExp.$2);
        alert ("公式不正确，请检查括号及+-*/是否匹配！");
        return;
    }
    reVal = /(\\]|\\)|>)([^>\\)\\+\\-\\*\\/]|[\\+\\-\\*\\/';
  echo ']{2,})/;
    if (reVal.test(document.formMain.textFormula.value))
    {
        //alert (RegExp.$1 +"2\\n"+RegExp.$2);
        alert ("公式不正确，请检查括号及+-*/是否匹配！");
        return;
    }
   var s1=document.formMain.textFormula.value;
	 var re;
   //alert(s1);
   re=/\\[([^$,\\]])*/gi;
   var r=s1.replace(re, "[");
   //alert(r);
     parent_window.form1.FORMULA.value=r;
  ';
  echo ' parent_window.form1.FORMULANAME.value=document.formMain.textFormula.value;
   parent.close();
}
function UpdateInfo(ITEM_ID)
{
    if (document.formMain.textFormula.value == "")
    {
        alert ("请输入公式内容！");
        document.formMain.textFormula.focus ();
        return;
    }
    reVal = /([^<\\(\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})(\\[|\\(|<)/;
    if (reVal.test(document.formMain.te';
  echo 'xtFormula.value))
    {
        //alert (RegExp.$1 +"1\\n"+RegExp.$2);
        alert ("公式不正确，请检查括号及+-*/是否匹配！");
        return;
    }
    reVal = /(\\]|\\)|>)([^>\\)\\+\\-\\*\\/]|[\\+\\-\\*\\/]{2,})/;
    if (reVal.test(document.formMain.textFormula.value))
    {
        //alert (RegExp.$1 +"2\\n"+RegExp.$2);
        alert ("公式不正确，请检查括号及+-*/是否匹配！");
        return';
  echo ';
    }
   var s1=document.formMain.textFormula.value;
	 var re;
   re=/\\[([^$,\\]])*/gi;
   var r=s1.replace(re, "[");
   document.formMain.FormulaID.value=r;
   formMain.submit();
}
function SetValue(itemid)
{
	 if(itemid=="")
    {
    	document.all("FormulaID").value=parent_window.form1.FORMULA.value;
    	document.all("textFormula").value=parent_window.form1.FORMULA';
  echo 'NAME.value;
    }
}
</script>
</HEAD>
<BODY class="panel" onload="SetValue(\'';
  echo $ITEM_ID;
  echo '\')">
<form method="POST" action="formula_edit.php?ITEM_ID=';
  echo $ITEM_ID;
  echo '&FLAG=1" name="formMain" >
<input type="hidden" name="FormulaID" value="';
  echo $FORMULA;
  echo '">
  <table  border="0" cellspacing="0" cellpadding="0" align="center" class="small">
    <tr>
      <td colspan="5">
        <table border="0" cellpadding="0" cellspacing="0" width="500">
          <tr class="TableHeader">
            <td align="left">
            	 &nbsp; &nbsp;
';
  if (($ITEM_ID == ''))
  {
    echo '               ';
    echo '<s';
    echo 'cript language="javascript">
               	if(parent_window.form1.ITEM_NAME.value!="")
               	document.write(parent_window.form1.ITEM_NAME.value+"=")
               </script>
';
  }
  else
  {
    echo ($ITEM_NAME.'=');
  }
  echo '            </td>
          </tr>
          <tr class="TableData">
          <td>
         <textarea name="textFormula" cols="80" rows="5" class="formclass" onSelect="storeCaret(this);" onClick="storeCaret(this);" onKeyup="storeCaret(this);">';
  echo $FORMULANAME;
  echo '</textarea>
         </td>
         </tr>
        </table>
      </td>
    </tr>
    <tr>
      <td width="53%" colspan="5">
      	<br><b>可选字段</b></td>
    </tr>
    <tr>
      <td width="12%">
        ';
  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 + \']\');">
';
  $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>
';
  }
  echo '          </select>
       </td>
      <td width="16%">
        <table width="159">
           <tr valign="middle">
            <td width="35" >
              <input type="button" name="btnAdd" value=" 1 " class="formclass_show4" onClick="insertAtCaret(document.formMain.textFormula, \'1\');">
            </td>
            <td width="35" >
              <input type="button" name="btnDec" value=" 2 " c';
  echo 'lass="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'2\');">
            </td>
            <td width="35" >
              <input type="button" name="btnMul" value=" 3 " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'3\');">
            </td>
            <td width="36" >
              <input type="button" name="btnAdd" value=" + " class="formcl';
  echo 'ass_show4" onClick="insertAtCaret(document.formMain.textFormula, \'+\');">
            </td>
          </tr>
            <tr valign="middle">
            <td width="35" >
              <input type="button" name="btnAdd" value=" 4 " class="formclass_show4" onClick="insertAtCaret(document.formMain.textFormula, \'4\');">
            </td>
            <td width="35" >
              <input type="button" na';
  echo 'me="btnDec" value=" 5 " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'5\');">
            </td>
            <td width="35" >
              <input type="button" name="btnMul" value=" 6 " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'6\');">
            </td>
             <td width="36" >
              <input type="button" name="btnDec"';
  echo ' value=" - " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'-\');">
            </td>
          </tr>
           <tr valign="middle">
            <td width="35" >
              <input type="button" name="btnAdd" value=" 7 " class="formclass_show4" onClick="insertAtCaret(document.formMain.textFormula, \'7\');">
            </td>
            <td width="35" >
         ';
  echo '     <input type="button" name="btnDec" value=" 8 " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'8\');">
            </td>
            <td width="35" >
              <input type="button" name="btnMul" value=" 9 " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'9\');">
            </td>
            <td width="36" >
              <input t';
  echo 'ype="button" name="btnMul" value=" * " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'*\');">
            </td>
          </tr>
          <tr valign="middle">
          	 <td width="35" >
              <input type="button" name="btnDiv" value=" 0 " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'0\');">
            </td>
             ';
  echo '<td width="35" >
              <input type="button" name="btnDiv" value=" . " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'.\');">
            </td>
             <td width="35" >
              <input type="button" name="btnLeft" value=" = " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'=\');">
            </td>
            <td width="';
  echo '36" >
              <input type="button" name="btnDiv" value=" / " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'/\');">
            </td>
          </tr>
           <tr valign="middle">
           <td width="35" >
              <input type="button" name="btnLeft" value=" < " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'<\');">
    ';
  echo '        </td>
            <td width="35">
              <input type="button" name="btnRight" value=" > " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'>\');">
            </td>
             <td width="35" >
              <input type="button" name="btnLeft" value=" ( " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \'(\');">
            </';
  echo 'td>
            <td width="36">
              <input type="button" name="btnRight" value=" ) " class="formclass_show4" onclick="insertAtCaret(document.formMain.textFormula, \')\');">
            </td>
            </tr>
          <tr>
            <td colspan="2">
              <input type="button" name="btnCheck" value=" 校验 " class="formclass_show4" onClick="funCheck ()">
            </td>
     ';
  echo '        <td colspan="2">
             &nbsp;
';
  if (($ITEM_ID == ''))
  {
    echo '             <input type="button" name="btnCheck" value=" 确定 " class="formclass_show4" onClick="SaveInfo()">
';
  }
  else
  {
    echo '             <input type="submit" value=" 保存 " class="formclass_show4"   name="button" onClick="UpdateInfo(\'';
    echo $ITEM_ID;
    echo '\')">
';
  }
  echo '            </td>
          </tr>
        </table>
      </td>
      <td width="1%" >　</td>
      <td width="24%" >';
  message ('说明', '个人所得税的输入为<参与所得税计算的工资项目>-个税起征额。例如\'<[应发工资]>-800\'(表示的是[应发工资]参与所得税计算)或是<[标准工资]+[奖金]>-800(表示的是[标准工资]与[奖金]之和参与所得税计算');
  echo '</td>
    </tr>
  </table>
</form>
</BODY>
</HTML>
';
?>

formula_edit.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 formula_edit.php 源码文件，采用 PHP 编程语言编写，共 385 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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