if (!$_POST['OSVF2']) { $fields['OSVF2'] = '0'; } if (!$_POST['OSVF3']) { $fields['OSVF3'] = '0'; } if (!$_POST['OSVF4']) { $fields['OSVF4'] = '0'; } if (!$_POST['TEST']) { $fields['Resource'] = ''; } if (!$fields['PLAN']) { $fields['PLAN'] = '0'; } $success = formUpdate($table_name, $fields, $form_id, $_SESSION['userauthorized']); //now save any Wear RXs (1-4) entered. $rx_number = '1'; if ($_POST['W_1'] == '1') { $query = "REPLACE INTO `form_eye_mag_wearing` (`ENCOUNTER` ,`FORM_ID` ,`PID` ,`RX_NUMBER` ,`ODSPH` ,`ODCYL` ,`ODAXIS` ,\n `ODVA` ,`ODADD` ,`ODNEARVA` ,`OSSPH` ,`OSCYL` ,`OSAXIS` ,\n `OSVA` ,`OSADD` ,`OSNEARVA` ,`ODMIDADD` ,`OSMIDADD` ,\n `RX_TYPE` ,`COMMENTS`,\n `ODHPD`,`ODHBASE`,`ODVPD`,`ODVBASE`,`ODSLABOFF`,`ODVERTEXDIST`,\n `OSHPD`,`OSHBASE`,`OSVPD`,`OSVBASE`,`OSSLABOFF`,`OSVERTEXDIST`,\n `ODMPDD`,`ODMPDN`,`OSMPDD`,`OSMPDN`,`BPDD`,`BPDN`,`LENS_MATERIAL`,\n `LENS_TREATMENTS`\n ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; $LENS_TREATMENTS_1 = implode("|", $_POST['LENS_TREATMENTS_1']); sqlQuery($query, array($encounter, $form_id, $pid, $rx_number, $_POST['ODSPH_1'], $_POST['ODCYL_1'], $_POST['ODAXIS_1'], $_POST['ODVA_1'], $_POST['ODADD_1'], $_POST['ODNEARVA_1'], $_POST['OSSPH_1'], $_POST['OSCYL_1'], $_POST['OSAXIS_1'], $_POST['OSVA_1'], $_POST['OSADD_1'], $_POST['OSNEARVA_1'], $_POST['ODMIDADD_1'], $_POST['OSMIDADD_1'], 0 + $_POST['RX_TYPE_1'], $_POST['COMMENTS_1'], $_POST['ODHPD_1'], $_POST['ODHBASE_1'], $_POST['ODVPD_1'], $_POST['ODVBASE_1'], $_POST['ODSLABOFF_1'], $_POST['ODVERTEXDIST_1'], $_POST['OSHPD_1'], $_POST['OSHBASE_1'], $_POST['OSVPD_1'], $_POST['OSVBASE_1'], $_POST['OSSLABOFF_1'], $_POST['OSVERTEXDIST_1'], $_POST['ODMPDD_1'], $_POST['ODMPDN_1'], $_POST['OSMPDD_1'], $_POST['OSMPDN_1'], $_POST['BPDD_1'], $_POST['BPDN_1'], $_POST['LENS_MATERIAL_1'], $LENS_TREATMENTS_1)); $rx_number++; } else { $query = "DELETE FROM form_eye_mag_wearing where ENCOUNTER=? and PID=? and FORM_ID=? and RX_NUMBER=?"; sqlQuery($query, array($encounter, $pid, $form_id, '1')); } if ($_POST['W_2'] == '1') { //store W_2 $query = "REPLACE INTO `form_eye_mag_wearing` (`ENCOUNTER` ,`FORM_ID` ,`PID` ,`RX_NUMBER` ,`ODSPH` ,`ODCYL` ,`ODAXIS` ,\n `ODVA` ,`ODADD` ,`ODNEARVA` ,`OSSPH` ,`OSCYL` ,`OSAXIS` ,\n `OSVA` ,`OSADD` ,`OSNEARVA` ,`ODMIDADD` ,`OSMIDADD` ,\n `RX_TYPE` ,`COMMENTS`,\n `ODHPD`,`ODHBASE`,`ODVPD`,`ODVBASE`,`ODSLABOFF`,`ODVERTEXDIST`,\n `OSHPD`,`OSHBASE`,`OSVPD`,`OSVBASE`,`OSSLABOFF`,`OSVERTEXDIST`,\n `ODMPDD`,`ODMPDN`,`OSMPDD`,`OSMPDN`,`BPDD`,`BPDN`,`LENS_MATERIAL`,\n `LENS_TREATMENTS`\n ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; $LENS_TREATMENTS_2 = implode("|", $_POST['LENS_TREATMENTS_2']);
// Created by: Larry Lart // Version: 1.0 - 30-03-2008 //////////////////////////////////////////////////////////////////// include_once "../../globals.php"; include_once "{$srcdir}/api.inc"; include_once "{$srcdir}/forms.inc"; foreach ($_POST as $k => $var) { $_POST[$k] = mysql_real_escape_string($var); // echo "$var\n"; } if ($encounter == "") { $encounter = date("Ymd"); } if ($_GET["mode"] == "new") { if ($_GET["id"] != '') { $_GET["id"] = '0'; $newid = formSubmit("form_brief_aan_verwijzer", $_POST, $_GET["id"], $userauthorized); // add shoul be here or downoutside if block ? addForm($encounter, "Psychiatric Brief Letter", $newid, "brief_aan_verwijzer", $pid, $userauthorized); } else { $_POST['autosave_flag'] = 0; $newid = formUpdate("form_brief_aan_verwijzer", $_POST, $_GET["saveid"], $userauthorized); } } elseif ($_GET["mode"] == "update") { $strSql = "UPDATE form_brief_aan_verwijzer\n SET pid = " . $_SESSION["pid"] . ", groupname='" . $_SESSION["authProvider"] . "', user='******', \n authorized={$userauthorized}, activity=1, date = NOW(), \n introductie='" . $_POST["introductie"] . "',\n reden_van_aanmelding='" . $_POST["reden_van_aanmelding"] . "', \n anamnese='" . $_POST["anamnese"] . "',\n psychiatrisch_onderzoek='" . $_POST["psychiatrisch_onderzoek"] . "',\n beschrijvend_conclusie='" . $_POST["beschrijvend_conclusie"] . "',\n advies_beleid='" . $_POST["advies_beleid"] . "',\n autosave_flag=0, \n autosave_datetime=NOW() \n WHERE id = " . $_GET['id'] . ";"; sqlQuery($strSql); } $_SESSION["encounter"] = $encounter; formHeader("Redirecting...."); formJump(); formFooter();
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. --> <?php include_once "../../globals.php"; include_once "{$srcdir}/api.inc"; include_once "{$srcdir}/forms.inc"; /* * name of the database table associated with this form */ $table_name = "form_note"; if ($encounter == "") { $encounter = date("Ymd"); } if ($_GET["mode"] == "new") { $newid = formSubmit($table_name, $_POST, $_GET["id"], $userauthorized); addForm($encounter, "Work/School Note", $newid, "note", $pid, $userauthorized); } elseif ($_GET["mode"] == "update") { $success = formUpdate($table_name, $_POST, $_GET["id"], $userauthorized); } $_SESSION["encounter"] = $encounter; formHeader("Redirecting...."); formJump(); formFooter();
// Package: Report of First visit - Dutch specific form // Created by: Larry Lart // Version: 1.0 - 27-03-2008 //////////////////////////////////////////////////////////////////// include_once "../../globals.php"; include_once "{$srcdir}/api.inc"; include_once "{$srcdir}/forms.inc"; foreach ($_POST as $k => $var) { $_POST[$k] = add_escape_custom($var); // echo "$var\n"; } if ($encounter == "") { $encounter = date("Ymd"); } if ($_GET["mode"] == "new") { if ($_GET["id"] != '') { $_GET["id"] = '0'; $newid = formSubmit("form_intakeverslag", $_POST, $_GET["id"], $userauthorized); // moved here ? addForm($encounter, "Psychiatric Intake", $newid, "intakeverslag", $pid, $userauthorized); } else { $_POST['autosave_flag'] = 0; $newid = formUpdate("form_intakeverslag", $_POST, $_GET["saveid"], $userauthorized); } } elseif ($_GET["mode"] == "update") { sqlQuery("UPDATE form_intakeverslag \n SET pid = " . $_SESSION["pid"] . ", groupname='" . $_SESSION["authProvider"] . "', user='******', \n authorized={$userauthorized}, activity=1, date = NOW(), \n intakedatum='" . $_POST["intakedatum"] . "',\n reden_van_aanmelding='" . $_POST["reden_van_aanmelding"] . "', \n klachten_probleemgebieden='" . $_POST["klachten_probleemgebieden"] . "',\n hulpverlening_onderzoek='" . $_POST["hulpverlening_onderzoek"] . "',\n hulpvraag_en_doelen='" . $_POST["hulpvraag_en_doelen"] . "',\n bijzonderheden_systeem='" . $_POST["bijzonderheden_systeem"] . "',\n werk_opleiding_vrije_tijdsbesteding='" . $_POST["werk_opleiding_vrije_tijdsbesteding"] . "',\n relatie_kinderen='" . $_POST["relatie_kinderen"] . "',\n somatische_context='" . $_POST["somatische_context"] . "',\n alcohol='" . $_POST["alcohol"] . "',\n drugs='" . $_POST["drugs"] . "',\n roken='" . $_POST["roken"] . "',\n medicatie='" . $_POST["medicatie"] . "',\n familieanamnese='" . $_POST["familieanamnese"] . "',\n indruk_observaties='" . $_POST["indruk_observaties"] . "',\n beschrijvende_conclusie='" . $_POST["beschrijvende_conclusie"] . "',\n behandelvoorstel='" . $_POST["behandelvoorstel"] . "',\n autosave_flag=0, \n autosave_datetime=0 \n WHERE id = " . $_GET["id"] . ";"); } $_SESSION["encounter"] = $encounter; formHeader("Redirecting...."); formJump(); formFooter();
$table_name = "form_eye_mag_dispense"; $query = "show columns from " . $table_name; $dispense_fields = sqlStatement($query); $fields = array(); if (sqlNumRows($dispense_fields) > 0) { while ($row = sqlFetchArray($dispense_fields)) { //exclude critical columns/fields, define below as needed if ($row['Field'] == 'id' || $row['Field'] == 'pid' || $row['Field'] == 'user' || $row['Field'] == 'groupname' || $row['Field'] == 'authorized' || $row['Field'] == 'activity') { continue; } if (isset($_POST[$row['Field']])) { $fields[$row['Field']] = $_POST[$row['Field']]; } } $fields['RXTYPE'] = $RXTYPE; $insert_this_id = formUpdate($table_name, $fields, $_POST['id'], $_SESSION['userauthorized']); } exit; } elseif ($_REQUEST['mode'] == "remove") { $query = "DELETE FROM form_eye_mag_dispense where id=?"; sqlStatement($query, array($_REQUEST['delete_id'])); echo xlt('Prescription successfully removed.'); exit; } elseif ($_REQUEST['RXTYPE']) { //store any changed fields $query = "UPDATE form_eye_mag_dispense set RXTYPE=? where id=?"; sqlStatement($query, array($_REQUEST['RXTYPE'], $_REQUEST['id'])); exit; } formHeader("Rx Vision: " . $prov_data[facility]); if ($_REQUEST['REFTYPE']) {