change_caselog.php3

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

<?
################################################################
#
#  CHANGE CASELOG
#
################################################################

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

/* process */
settype($duration,"integer");

$datas['user_id']      = $user->ent_id;
$datas['duration']     = $duration;
$datas['clog_id']      = $clog_id;
$datas['caselog_text'] = addslashes($caselog_text);
$datas['cas_id']       = $cas_id;

$header_location = "display_case.php3?cas_id=$cas_id";

switch ($mode)
{
  //###################
  // OUVERTURE D'UN LOG
  //###################
 case "new":
   SQL_BEGIN($dbproc);
   $datas['clog_startdate'] = SQL_TIME (0,0,0,0,0,30,'datetime');
   $datas['clog_id'] = SQL_CASELOG_INSERT ($dbproc, $datas);

   if ($datas['clog_id'] > 0)
     {
       SQL_COMMIT($dbproc);
       $clog_id = $datas['clog_id'];

       if (!trim($caselog_text))
     $header_location = "display_caselog.php3?cas_id=$cas_id&clog_id=$clog_id&mode=edit";

       elseif ($saveclose)
     {
       if ($duration == 0)
         $header_location = "display_caselog.php3?cas_id=$cas_id&clog_id=$clog_id&mode=edit&warning_nulldur=1";
       else
         SQL_CLOSE_CASELOG($dbproc,$datas);
     }
     }
   else
     SQL_ROLLBACK($dbproc);
   break;


   //###################
   // EDITION  D'UN LOG
   //###################
   case "edit";
   SQL_BEGIN($dbproc);

   $result = SQL_CASETEXT_UPDATE($dbproc,$datas);
   $result2 = SQL_CASELOG_UPDATE($dbproc,$datas);

   if ($result > 0 AND $result2 > 0)
     SQL_COMMIT($dbproc);
   else
     SQL_ROLLBACK($dbproc);

   if (!$saveclose)
     {
       if (!trim($caselog_text))
     $header_location = "display_caselog.php3?cas_id=$cas_id&clog_id=$clog_id&mode=edit";

       elseif ($duration == 0)
     $header_location = "display_caselog.php3?cas_id=$cas_id&clog_id=$clog_id&mode=edit&warning_nulldur=1";
       break;
     }

   //###################
   // FERMETURE D'UN LOG
   //###################
 case "close":
   if ((!trim($caselog_text) and $mode != "close") or $duration == 0)
     {
       $header_location = "display_caselog.php3?cas_id=$cas_id&clog_id=$clog_id&mode=edit";
       if ($duration == 0)
     $header_location .= "&warning_nulldur=1";
     }
   else
     SQL_CLOSE_CASELOG($dbproc,$datas);
   break;
 default:
}
SQL_CLOSE($dbproc);
header("location:$header_location");
?>