add_ctrcontact_do.php3

来自「FIREFLY 是一个多用户专业帮助桌面系统」· PHP3 代码 · 共 48 行

<?
################################################################
#
#  ADD CONTRACT
#
#
################################################################

/* init */
include ("../include/levels.php3");
$access_level = $r_level["admin"];
include ("../include/config.php3");

/* process */
if ($mode == 'delete')
{
  $query = "DELETE FROM ctrper WHERE ctr_per_id=$ctr_per_id";
  if ($ctr_per_id)
    SQL_QUERY ($query,$dbproc);
}
else
{
  $query   = "SELECT cdet_id FROM ctrdetail  WHERE ctr_id ='$ctr_id' ";
  $res     = SQL_QUERY ($query,$dbproc);
  $result  = SQL_FETCH_RESULT($res);
  $cdet_id = $result[0]["cdet_id"];
  $query   = "SELECT ctr_per_id FROM  ctrper  WHERE cdet_id='$cdet_id' AND per_id = '$per_id' ";
  $res     = SQL_QUERY ($query,$dbproc);

  if (SQL_NUM_ROWS($res) == 0)
    {
      SQL_BEGIN($dbproc);
      $result = SQL_FETCH_RESULT ($res);
      $datas['cdet_id'] = $cdet_id;
      $datas['per_id'] = $per_id;
      $datas['user_id'] = $user->ent_id;
      $res = SQL_CTR_PER_INSERT ($dbproc, $datas );
      if ($res == -1)
    SQL_ROLLBACK ($dbproc);
      else
    SQL_COMMIT ($dbproc);
    }
  else
    SQL_FREE_RESULT($res);
}
header ("location:display_contract.php3?ctr_id=$ctr_id");
?>