📄 check_cfg.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  function check_assetcfg ()
  {
    global $connection;
    $query = 'SELECT * from CP_ASSETCFG';
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $BAL_SORT = $ROW['BAL_SORT'];
      $DPCT_SORT = $ROW['DPCT_SORT'];
    }
    else
    {
      echo '<html>
<head>
<title>增加固定资产</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
      message ('', '未配置参数，请先到“参数设置”模块中设置参数');
      echo '</body>
</html>
';
      exit ();
    }
  }
  function check_dpct ()
  {
    global $connection;
    $query = 'SELECT * from CP_ASSETCFG';
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $DPCT_SORT = $ROW['DPCT_SORT'];
    }
    $CUR_DATE = getdate ();
    $CUR_MON = $CUR_DATE['mon'];
    if ((($DPCT_SORT == 'S') AND (0 < ($CUR_MON % 3))))
    {
      message ('', '只能在3、6、9、12月进行折旧');
      exit ();
    }
    else
    {
      if ((($DPCT_SORT == 'Y') AND (0 < ($CUR_MON % 12))))
      {
        message ('', '只能在12月进行折旧');
        exit ();
      }
    }
  }
  function check_depre_date ($DEPRE_DATE)
  {
    $CUR_DATE = date ('Y-m-d', time ());
    $CUR_DATE_ARRAY = explode ('-', $CUR_DATE);
    $DEPRE_DATE_ARRAY = explode ('-', $DEPRE_DATE);
    return (((($CUR_DATE_ARRAY[0] - $DEPRE_DATE_ARRAY[0]) * 12) + ($CUR_DATE_ARRAY[1] - $DEPRE_DATE_ARRAY[1])) + 1);
  }
  function insert_dpct ($DPCT_SORT, $FROM_YY, $FROM_MM, $MON_NUM, $MON_DPCT, $LEFT_VALUE, $SUM_DPCT, $CPTL_ID)
  {
    global $connection;
    $PEPRE_DATE = date ('Y-m-d', time ());
    if (($DPCT_SORT == 'M'))
    {
      $NUM = 1;
    }
    else
    {
      if (($DPCT_SORT == 'S'))
      {
        $NUM = 3;
      }
      else
      {
        if (($DPCT_SORT == 'Y'))
        {
          $NUM = 12;
        }
      }
    }
    $DPCT_COUNT = (($MON_NUM - ($MON_NUM % $NUM)) / $NUM);
    if ((0 < ($MON_NUM % $NUM)))
    {
      ++$DPCT_COUNT;
    }
    for ($I = 0; ($I < $DPCT_COUNT); ++$I)
    {
      if (($LEFT_VALUE <= 0))
      {
        break;
      }
      $TO_YY = $FROM_YY;
      $TO_MM = (($FROM_MM + $NUM) - 1);
      if ((($MON_DPCT * $NUM) <= $LEFT_VALUE))
      {
        $DEPRE_AMT = ($MON_DPCT * $NUM);
        if ((($I == 0) AND (0 < ($MON_NUM % $NUM))))
        {
          $DEPRE_AMT = ($MON_DPCT * ($MON_NUM % $NUM));
          $TO_MM = (($FROM_MM + ($MON_NUM % $NUM)) - 1);
        }
        if (($NUM == 1))
        {
          $TO_MM = ($FROM_MM + ($MON_NUM % $NUM));
        }
      }
      else
      {
        $DEPRE_AMT = $LEFT_VALUE;
        if (((($I == 0) AND (0 < ($MON_NUM % $NUM))) AND (($MON_DPCT * ($MON_NUM % $NUM)) < $LEFT_VALUE)))
        {
          $DEPRE_AMT = ($MON_DPCT * ($MON_NUM % $NUM));
          $TO_MM = (($FROM_MM + ($MON_NUM % $NUM)) - 1);
        }
        if (($NUM == 1))
        {
          $TO_MM = ($FROM_MM + ($MON_NUM % $NUM));
        }
      }
      if ((12 < $TO_MM))
      {
        ($TO_YY += 1);
        $TO_MM = ($TO_MM % 12);
      }
      $LEFT_VALUE = ($LEFT_VALUE - $DEPRE_AMT);
      if ((strlen ($FROM_MM) == 1))
      {
        $FROM_MM = ('0'.$FROM_MM);
      }
      if ((strlen ($TO_MM) == 1))
      {
        $TO_MM = ('0'.$TO_MM);
      }
      $FROM_YYMM = (($FROM_YY.'-').$FROM_MM);
      $TO_YYMM = (($TO_YY.'-').$TO_MM);
      $query = (((((((((((''.'insert into CP_DPCT_SUB (CPTL_ID,PEPRE_DATE,FROM_YYMM,TO_YYMM,DEPRE_AMT) values(').$CPTL_ID).',\'').$PEPRE_DATE).'\',\'').$FROM_YYMM).'\',\'').$TO_YYMM).'\',').$DEPRE_AMT).')');
      exequery ($connection, $query);
      ($SUM_DPCT += $DEPRE_AMT);
      $FROM_YY = $TO_YY;
      $FROM_MM = ($TO_MM + 1);
      if ((12 < $FROM_MM))
      {
        ($FROM_YY += 1);
        $FROM_MM = ($FROM_MM % 12);
        continue;
      }
    }
    $query = ((((''.'update CP_CPTL_INFO set SUM_DPCT=').$SUM_DPCT).' where CPTL_ID=').$CPTL_ID);
    exequery ($connection, $query);
  }
  include_once 'inc/auth.php';
?>
⌨️ 快捷键说明

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