📄 update.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 (($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 ();
  }
  $UPDATE_STR = ((((((((((((((''.'CPTL_NO=\'').$CPTL_NO).'\',CPTL_NAME=\'').$CPTL_NAME).'\',TYPE_ID=').$TYPE_ID).',DEPT_ID=').$DEPT_ID).',CPTL_VAL=').$CPTL_VAL).',CPTL_KIND=\'').$CPTL_KIND).'\',PRCS_ID=').$PRCS_ID);
  if (($CPTL_BAL != ''))
  {
    ($UPDATE_STR .= ((''.',CPTL_BAL=').$CPTL_BAL));
  }
  else
  {
    ($UPDATE_STR .= ',CPTL_BAL=0');
  }
  if (($DPCT_YY != ''))
  {
    ($UPDATE_STR .= ((''.',DPCT_YY=').$DPCT_YY));
  }
  else
  {
    ($UPDATE_STR .= ',DPCT_YY=0');
  }
  if (($SUM_DPCT != ''))
  {
    ($UPDATE_STR .= ((''.',SUM_DPCT=').$SUM_DPCT));
  }
  else
  {
    ($UPDATE_STR .= ',SUM_DPCT=0');
  }
  if (($MON_DPCT != ''))
  {
    ($UPDATE_STR .= ((''.',MON_DPCT=').$MON_DPCT));
  }
  else
  {
    ($UPDATE_STR .= ',MON_DPCT=0');
  }
  if (($FINISH_FLAG != ''))
  {
    ($UPDATE_STR .= (((''.',FINISH_FLAG=\'').$FINISH_FLAG).'\''));
  }
  ($UPDATE_STR .= (((((((((''.',CREATE_DATE=\'').$CUR_DATE).'\',FROM_YYMM=\'').$FROM_YYMM).'\',KEEPER=\'').$KEEPER).'\',REMARK=\'').$REMARK).'\''));
  $query = ((((''.'update CP_CPTL_INFO set ').$UPDATE_STR).' where CPTL_ID=').$CPTL_ID);
  exequery ($connection, $query);
  header ('location: index.php');
  echo '
</body>
</html>
';
?>
⌨️ 快捷键说明

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