contrib/forms/psychiatrySet/brief_aan_verwijzer/delete_autosave.php

   1 <?php
   2 ////////////////////////////////////////////////////////////////////
   3 // Form:        Brief Aan Verwijzer - Delete Autosave
   4 // Package:     remove autosaved form  - Dutch specific form
   5 // Created by:  Larry Lart
   6 // Version:     1.0 - 30-03-2008
   7 ////////////////////////////////////////////////////////////////////
   8
   9 //local includes
  10 include_once("../../globals.php");
  11
  12 /////////////////
  13 // here we check to se if there was an autosave version prior to the real save - hack!
  14 $vectAutosave = sqlQuery("SELECT id, autosave_flag, autosave_datetime FROM form_brief_aan_verwijzer
  15                             WHERE pid = ".$_SESSION["pid"].
  16                             " AND groupname='".$_SESSION["authProvider"].
  17                             "' AND user='".$_SESSION["authUser"]."' AND
  18                             authorized=$userauthorized AND activity=1
  19                             AND autosave_flag=1
  20                             ORDER by id DESC limit 1");
  21
  22 if ($vectAutosave['autosave_flag'] == 1) {
  23     $strSql = "DELETE from  form_brief_aan_verwijzer
  24                   WHERE id = ".$vectAutosave['id'].";";
  25     sqlQuery($strSql);
  26 }
  27
  28 //echo "debug :: form was deleted... sql=$strSql";