contrib/forms/psychiatrySet/intakeverslag/autosave.php

   1 <?php
   2 ////////////////////////////////////////////////////////////////////
   3 // Form:        Intakeverslag - Autosave
   4 // Package:     Report of First visit - Dutch specific form
   5 // Created by:  Larry Lart
   6 // Version:     1.0 - 28-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 //echo "intakedatum=".$_POST["intakedatum"];
  15 //var_dump($_POST);
  16
  17 // escape the strings
  18 foreach ($_POST as $k => $var) {
  19     $_POST[$k] = add_escape_custom($var);
  20   // echo "$var\n";
  21 }
  22
  23 /////////////////
  24 // here we check to se if there was an autosave version prior to the real save
  25 $vectAutosave = sqlQuery("SELECT id, autosave_flag, autosave_datetime FROM form_intakeverslag
  26                             WHERE pid = ".$_SESSION["pid"].
  27                             " AND groupname='".$_SESSION["authProvider"].
  28                             "' AND user='".$_SESSION["authUser"]."' AND
  29                             authorized=$userauthorized AND activity=1
  30                             AND autosave_flag=1
  31                             ORDER by id DESC limit 1");
  32
  33 // if yes then update this else insert
  34 if ($vectAutosave['autosave_flag'] == 1 || $_POST["mode"] == "update") {
  35     if ($_POST["mode"] == "update") {
  36         $newid = $_POST["id"];
  37     } else {
  38         $newid = $vectAutosave['id'];
  39     }
  40
  41     $strSql = "UPDATE form_intakeverslag
  42                 SET pid = ".$_SESSION["pid"].", groupname='".$_SESSION["authProvider"]."', user='".$_SESSION["authUser"]."',
  43                 authorized=$userauthorized, activity=1, date = NOW(),
  44                 intakedatum='".$_POST["intakedatum"]."',
  45                 reden_van_aanmelding='".$_POST["reden_van_aanmelding"]."',
  46                 klachten_probleemgebieden='".$_POST["klachten_probleemgebieden"]."',
  47                 hulpverlening_onderzoek='".$_POST["hulpverlening_onderzoek"]."',
  48                 hulpvraag_en_doelen='".$_POST["hulpvraag_en_doelen"]."',
  49                 bijzonderheden_systeem='".$_POST["bijzonderheden_systeem"]."',
  50                 werk_opleiding_vrije_tijdsbesteding='".$_POST["werk_opleiding_vrije_tijdsbesteding"]."',
  51                 relatie_kinderen='".$_POST["relatie_kinderen"]."',
  52                 somatische_context='".$_POST["somatische_context"]."',
  53                 alcohol='".$_POST["alcohol"]."',
  54                 drugs='".$_POST["drugs"]."',
  55                 roken='".$_POST["roken"]."',
  56                 medicatie='".$_POST["medicatie"]."',
  57                 familieanamnese='".$_POST["familieanamnese"]."',
  58                 indruk_observaties='".$_POST["indruk_observaties"]."',
  59                 beschrijvende_conclusie='".$_POST["beschrijvende_conclusie"]."',
  60                 behandelvoorstel='".$_POST["behandelvoorstel"]."',
  61                 autosave_flag=1,
  62                 autosave_datetime=NOW()
  63                   WHERE id = ".$newid.";";
  64
  65     sqlQuery($strSql);
  66
  67 //echo "lalalalal id=$newid, sql=$strSql<br>";
  68 } else {
  69     $newid = formSubmit("form_intakeverslag", $_POST, $_GET["id"], $userauthorized);
  70     addForm($encounter, "Psychiatric Intake", $newid, "intakeverslag", $pid, $userauthorized);
  71
  72     //echo "debug :: insert<br>";
  73 }
  74
  75
  76 //get timestamp
  77 $result = sqlQuery("SELECT autosave_datetime FROM form_intakeverslag
  78                             WHERE pid = ".$_SESSION["pid"].
  79                             " AND groupname='".$_SESSION["authProvider"].
  80                             "' AND user='".$_SESSION["authUser"]."' AND
  81                             authorized=$userauthorized AND activity=1 AND id=$newid
  82                             AND autosave_flag=1
  83                             ORDER by id DESC limit 1");
  84 //$timestamp = mysql_result($result, 0);
  85
  86 //output timestamp
  87 echo xl('Last Saved') . ': '.$result['autosave_datetime'];