contrib/forms/psychiatrySet/brief_aan_verwijzer/autosave.php

   1 <?php
   2 ////////////////////////////////////////////////////////////////////
   3 // Form:        form_brief_aan_verwijzer - Autosave
   4 // Package:     letter to... - Dutch specific form
   5 // Created by:  Larry Lart
   6 // Version:     1.0 - 29-03-2008
   7 ////////////////////////////////////////////////////////////////////
   8
   9 //local includes
  10 include_once("../../globals.php");
  11 include_once("$srcdir/api.inc");
  12 include_once("$srcdir/forms.inc");
  13
  14
  15 // escape the strings
  16 foreach ($_POST as $k => $var) {
  17     $_POST[$k] = add_escape_custom($var);
  18   // echo "$var\n";
  19 }
  20
  21 /////////////////
  22 // here we check to se if there was an autosave version prior to the real save
  23 $vectAutosave = sqlQuery("SELECT id, autosave_flag, autosave_datetime FROM form_brief_aan_verwijzer
  24                             WHERE pid = ".$_SESSION["pid"].
  25                             " AND groupname='".$_SESSION["authProvider"].
  26                             "' AND user='".$_SESSION["authUser"]."' AND
  27                             authorized=$userauthorized AND activity=1
  28                             AND autosave_flag=1
  29                             ORDER by id DESC limit 1");
  30
  31 // if yes then update this else insert
  32 if ($vectAutosave['autosave_flag'] == 1 || $_POST["mode"] == "update") {
  33     if ($_POST["mode"] == "update") {
  34         $newid = $_POST["id"];
  35     } else {
  36         $newid = $vectAutosave['id'];
  37     }
  38
  39     $strSql = "UPDATE form_brief_aan_verwijzer
  40                 SET pid = ".$_SESSION["pid"].", groupname='".$_SESSION["authProvider"]."', user='".$_SESSION["authUser"]."',
  41                 authorized=$userauthorized, activity=1, date = NOW(),
  42                 introductie='".$_POST["introductie"]."',
  43                 reden_van_aanmelding='".$_POST["reden_van_aanmelding"]."',
  44                 anamnese='".$_POST["anamnese"]."',
  45                 psychiatrisch_onderzoek='".$_POST["psychiatrisch_onderzoek"]."',
  46                 beschrijvend_conclusie='".$_POST["beschrijvend_conclusie"]."',
  47                 advies_beleid='".$_POST["advies_beleid"]."',
  48                 autosave_flag=1,
  49                 autosave_datetime=NOW()
  50                   WHERE id = ".$newid.";";
  51
  52     sqlQuery($strSql);
  53
  54 //echo "DEBUG :: id=$newid, sql=$strSql<br>";
  55 } else {
  56     $newid = formSubmit("form_brief_aan_verwijzer", $_POST, $_GET["id"], $userauthorized);
  57     addForm($encounter, "Psychiatric Brief Letter", $newid, "brief_aan_verwijzer", $pid, $userauthorized);
  58
  59     //echo "Debug :: insert<br>";
  60 }
  61
  62
  63 //get timestamp
  64 $result = sqlQuery("SELECT autosave_datetime FROM form_brief_aan_verwijzer
  65                             WHERE pid = ".$_SESSION["pid"].
  66                             " AND groupname='".$_SESSION["authProvider"].
  67                             "' AND user='".$_SESSION["authUser"]."' AND
  68                             authorized=$userauthorized AND activity=1 AND id=$newid
  69                             AND autosave_flag=1
  70                             ORDER by id DESC limit 1");
  71 //$timestamp = mysql_result($result, 0);
  72
  73 //output timestamp
  74 echo xl('Last Saved') . ': '.$result['autosave_datetime'];