📄 submit.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  echo '
<html>
<head>
<title>增加固定资产</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_DATE = date ('Y-m-d', time ());
  if (($CPTL_NAME == ''))
  {
    ($MSG_ST .= '"资产名称",');
  }
  if (($DEPT_ID == ''))
  {
    ($MSG_ST .= '"所属部门",');
  }
  if (($CPTL_KIND == ''))
  {
    ($MSG_ST .= '"资产性质",');
  }
  if (($PRCS_ID == ''))
  {
    ($MSG_ST .= '"增加类型",');
  }
  if (($KEEPER == ''))
  {
    ($MSG_ST .= '"保管人",');
  }
  if (($CPTL_KIND == '01'))
  {
    if (($FINISH_FLAG == ''))
    {
      ($MSG_ST .= '"折旧",');
    }
  }
  if (($MSG_STR != ''))
  {
    $MSG_STR = (substr ($MSG_STR, 0, -1).'不能为空');
    message ('', $MSG_STR);
  }
  $MSG_STR = '';
  if (!settype ($CPTL_VAL, 'float'))
  {
    ($MSG_ST .= '"资产原值",');
  }
  if (($CPTL_KIND == '01'))
  {
    if (!settype ($CPTL_BAL, 'float'))
    {
      ($MSG_STR .= '"折旧(率)",');
    }
    if (!settype ($DPCT_YY, 'float'))
    {
      ($MSG_STR .= '"折旧年限",');
    }
    if (!settype ($SUM_DPCT, 'float'))
    {
      ($MSG_STR .= '"累计折旧",');
    }
    if (!settype ($MON_DPCT, 'float'))
    {
      ($MSG_STR .= '"月折旧额",');
    }
  }
  else
  {
    if ((($CPTL_BAL != '') AND !settype ($CPTL_BAL, 'float')))
    {
      ($MSG_STR .= '"折旧(率)",');
    }
    if ((($DPCT_YY != '') AND !settype ($DPCT_YY, 'float')))
    {
      ($MSG_STR .= '"折旧年限",');
    }
    if ((($SUM_DPCT != '') AND !settype ($SUM_DPCT, 'float')))
    {
      ($MSG_STR .= '"累计折旧",');
    }
    if ((($MON_DPCT != '') AND !settype ($MON_DPCT, 'float')))
    {
      ($MSG_STR .= '"月折旧额",');
    }
  }
  if (($MSG_STR != ''))
  {
    $MSG_STR = (substr ($MSG_STR, 0, -1).'必须为数字');
    message ('', $MSG_STR);
    button_back ();
    exit ();
  }
  if ((($FROM_YYMM != '') AND !is_date ($FROM_YYMM)))
  {
    message ('', '"启用日期"应为日期型');
    button_back ();
    exit ();
  }
  $FIELD_STR = 'CPTL_NO,CPTL_NAME,TYPE_ID,DEPT_ID,CPTL_VAL,CPTL_KIND,PRCS_ID';
  $VALUE_STR = ((((((((((((((''.'\'').$CPTL_NO).'\',\'').$CPTL_NAME).'\',').$TYPE_ID).',').$DEPT_ID).',').$CPTL_VAL).',\'').$CPTL_KIND).'\',').$PRCS_ID);
  if (($CPTL_BAL != ''))
  {
    ($FIELD_STR .= ',CPTL_BAL');
    ($VALUE_STR .= (','.$CPTL_BAL));
  }
  if (($DPCT_YY != ''))
  {
    ($FIELD_STR .= ',DPCT_YY');
    ($VALUE_STR .= (','.$DPCT_YY));
  }
  if (($SUM_DPCT != ''))
  {
    ($FIELD_STR .= ',SUM_DPCT');
    ($VALUE_STR .= (','.$SUM_DPCT));
  }
  if (($MON_DPCT != ''))
  {
    ($FIELD_STR .= ',MON_DPCT');
    ($VALUE_STR .= (','.$MON_DPCT));
  }
  if (($FINISH_FLAG != ''))
  {
    ($FIELD_STR .= ',FINISH_FLAG');
    ($VALUE_STR .= ((',\''.$FINISH_FLAG).'\''));
  }
  ($FIELD_STR .= ',CREATE_DATE,FROM_YYMM,KEEPER,REMARK');
  ($VALUE_STR .= (((((((((''.',\'').$CUR_DATE).'\',\'').$FROM_YYMM).'\',\'').$KEEPER).'\',\'').$REMARK).'\''));
  $query = (((('insert into CP_CPTL_INFO ('.$FIELD_STR).') values(').$VALUE_STR).');');
  exequery ($connection, $query);
  header ('location: ../');
  echo '
</body>
</html>
';
?>
⌨️ 快捷键说明

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