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']) {
