function issue_football_injury_save($issue) { global $arr_activity, $arr_sanction, $arr_weather; $query = "REPLACE INTO lists_football_injury ( " . "id, fiinjmin, fiinjtime, fimatchtype, "; foreach ($arr_activity as $key => $value) { $query .= "fimech_{$key}, "; } foreach ($arr_sanction as $key => $value) { $query .= "fimech_{$key}, "; } foreach ($arr_weather as $key => $value) { $query .= "fiweather_{$key}, "; } $query .= "fimech_othercon, fimech_othernon, fiweather_temperature, " . "fisurface, fiposition, fifootwear, firemoved, ficondition " . ") VALUES ( " . $issue . ", " . invalue('form_injmin') . ", " . rbvalue('form_injtime') . ", " . rbvalue('form_matchtype') . ", "; foreach ($arr_activity as $key => $value) { $query .= cbvalue("form_mech_{$key}") . ", "; } foreach ($arr_sanction as $key => $value) { $query .= cbvalue("form_mech_{$key}") . ", "; } foreach ($arr_weather as $key => $value) { $query .= cbvalue("form_weather_{$key}") . ", "; } $query .= txvalue('form_mech_othercon') . ", " . txvalue('form_mech_othernon') . ", " . txvalue('form_weather_temperature') . ", " . rbvalue('form_surface') . ", " . rbvalue('form_position') . ", " . rbvalue('form_footwear') . ", " . rbvalue('form_removed') . ", " . rbvalue('form_condition') . " " . ")"; sqlStatement($query); }
} } </script> </head> <body class="body_top"> <?php // If we are saving, then save and close the window. // if ($_POST['form_save']) { if ($userid) { $query = "UPDATE users SET " . "abook_type = " . invalue('form_abook_type') . ", " . "title = " . invalue('form_title') . ", " . "fname = " . invalue('form_fname') . ", " . "lname = " . invalue('form_lname') . ", " . "mname = " . invalue('form_mname') . ", " . "specialty = " . invalue('form_specialty') . ", " . "organization = " . invalue('form_organization') . ", " . "valedictory = " . invalue('form_valedictory') . ", " . "assistant = " . invalue('form_assistant') . ", " . "federaltaxid = " . invalue('form_federaltaxid') . ", " . "upin = " . invalue('form_upin') . ", " . "npi = " . invalue('form_npi') . ", " . "taxonomy = " . invalue('form_taxonomy') . ", " . "email = " . invalue('form_email') . ", " . "url = " . invalue('form_url') . ", " . "street = " . invalue('form_street') . ", " . "streetb = " . invalue('form_streetb') . ", " . "city = " . invalue('form_city') . ", " . "state = " . invalue('form_state') . ", " . "zip = " . invalue('form_zip') . ", " . "street2 = " . invalue('form_street2') . ", " . "streetb2 = " . invalue('form_streetb2') . ", " . "city2 = " . invalue('form_city2') . ", " . "state2 = " . invalue('form_state2') . ", " . "zip2 = " . invalue('form_zip2') . ", " . "phone = " . invalue('form_phone') . ", " . "phonew1 = " . invalue('form_phonew1') . ", " . "phonew2 = " . invalue('form_phonew2') . ", " . "phonecell = " . invalue('form_phonecell') . ", " . "fax = " . invalue('form_fax') . ", " . "notes = " . invalue('form_notes') . " " . "WHERE id = '{$userid}'"; sqlStatement($query); } else { $userid = sqlInsert("INSERT INTO users ( " . "username, password, authorized, info, source, " . "title, fname, lname, mname, " . "federaltaxid, federaldrugid, upin, facility, see_auth, active, npi, taxonomy, " . "specialty, organization, valedictory, assistant, billname, email, url, " . "street, streetb, city, state, zip, " . "street2, streetb2, city2, state2, zip2, " . "phone, phonew1, phonew2, phonecell, fax, notes, abook_type " . ") VALUES ( " . "'', " . "'', " . "0, " . "'', " . "NULL, " . invalue('form_title') . ", " . invalue('form_fname') . ", " . invalue('form_lname') . ", " . invalue('form_mname') . ", " . invalue('form_federaltaxid') . ", " . "'', " . invalue('form_upin') . ", " . "'', " . "0, " . "1, " . invalue('form_npi') . ", " . invalue('form_taxonomy') . ", " . invalue('form_specialty') . ", " . invalue('form_organization') . ", " . invalue('form_valedictory') . ", " . invalue('form_assistant') . ", " . "'', " . invalue('form_email') . ", " . invalue('form_url') . ", " . invalue('form_street') . ", " . invalue('form_streetb') . ", " . invalue('form_city') . ", " . invalue('form_state') . ", " . invalue('form_zip') . ", " . invalue('form_street2') . ", " . invalue('form_streetb2') . ", " . invalue('form_city2') . ", " . invalue('form_state2') . ", " . invalue('form_zip2') . ", " . invalue('form_phone') . ", " . invalue('form_phonew1') . ", " . invalue('form_phonew2') . ", " . invalue('form_phonecell') . ", " . invalue('form_fax') . ", " . invalue('form_notes') . ", " . invalue('form_abook_type') . " " . ")"); } } else { if ($_POST['form_delete']) { if ($userid) { // Be careful not to delete internal users. sqlStatement("DELETE FROM users WHERE id = '{$userid}' AND username = ''"); } } } if ($_POST['form_save'] || $_POST['form_delete']) { // Close this window and redisplay the updated list. echo "<script language='JavaScript'>\n"; if ($info_msg) { echo " alert('{$info_msg}');\n"; }
} $(document).ready(function() { proc_type_changed(); }); </script> </head> <body class="body_top"> <?php // If we are saving, then save and close the window. // if ($_POST['form_save']) { $sets = "name = " . invalue('form_name') . ", " . "lab_id = " . invalue('form_lab_id') . ", " . "procedure_code = " . invalue('form_procedure_code') . ", " . "procedure_type = " . invalue('form_procedure_type') . ", " . "body_site = " . invalue('form_body_site') . ", " . "specimen = " . invalue('form_specimen') . ", " . "route_admin = " . invalue('form_route_admin') . ", " . "laterality = " . invalue('form_laterality') . ", " . "description = " . invalue('form_description') . ", " . "units = " . invalue('form_units') . ", " . "`range` = " . invalue('form_range') . ", " . "standard_code = " . invalue('form_standard_code') . ", " . "related_code = " . invalue('form_related_code') . ", " . "seq = " . invalue('form_seq'); if ($typeid) { sqlStatement("UPDATE procedure_type SET {$sets} WHERE procedure_type_id = '{$typeid}'"); // Get parent ID so we can refresh the tree view. $row = sqlQuery("SELECT parent FROM procedure_type WHERE " . "procedure_type_id = '{$typeid}'"); $parent = $row['parent']; } else { $newid = sqlInsert("INSERT INTO procedure_type SET parent = '{$parent}', {$sets}"); // $newid is not really used in this script } } else { if ($_POST['form_delete']) { if ($typeid) { // Get parent ID so we can refresh the tree view after deleting. $row = sqlQuery("SELECT parent FROM procedure_type WHERE " . "procedure_type_id = '{$typeid}'"); $parent = $row['parent'];
</style> <script language="JavaScript"> </script> </head> <body class="body_top"> <?php // If we are saving, then save and close the window. // if ($_POST['form_save']) { $org_qry = "SELECT organization FROM users WHERE id = ?"; $org_res = sqlQuery($org_qry, array($_POST['form_name'])); $org_name = $org_res['organization']; $sets = "name = '" . add_escape_custom($org_name) . "', " . "lab_director = " . invalue('form_name') . ", " . "npi = " . invalue('form_npi') . ", " . "send_app_id = " . invalue('form_send_app_id') . ", " . "send_fac_id = " . invalue('form_send_fac_id') . ", " . "recv_app_id = " . invalue('form_recv_app_id') . ", " . "recv_fac_id = " . invalue('form_recv_fac_id') . ", " . "DorP = " . invalue('form_DorP') . ", " . "direction = " . invalue('form_direction') . ", " . "protocol = " . invalue('form_protocol') . ", " . "remote_host = " . invalue('form_remote_host') . ", " . "login = "******", " . "password = "******", " . "orders_path = " . invalue('form_orders_path') . ", " . "results_path = " . invalue('form_results_path') . ", " . "notes = " . invalue('form_notes'); if ($ppid) { $query = "UPDATE procedure_providers SET {$sets} " . "WHERE ppid = '" . add_escape_custom($ppid) . "'"; sqlStatement($query); } else { $ppid = sqlInsert("INSERT INTO procedure_providers SET {$sets}"); } } else { if ($_POST['form_delete']) { if ($ppid) { sqlStatement("DELETE FROM procedure_providers WHERE ppid = ?", array($ppid)); } } } if ($_POST['form_save'] || $_POST['form_delete']) { // Close this window and redisplay the updated list.
font-size:9pt; font-weight:bold; } </style> <script language="JavaScript"> </script> </head> <body class="body_top"> <?php // If we are saving, then save and close the window. // if ($_POST['form_save']) { $sets = "name = " . invalue('form_name') . ", " . "npi = " . invalue('form_npi') . ", " . "send_app_id = " . invalue('form_send_app_id') . ", " . "send_fac_id = " . invalue('form_send_fac_id') . ", " . "recv_app_id = " . invalue('form_recv_app_id') . ", " . "recv_fac_id = " . invalue('form_recv_fac_id') . ", " . "DorP = " . invalue('form_DorP') . ", " . "protocol = " . invalue('form_protocol') . ", " . "remote_host = " . invalue('form_remote_host') . ", " . "login = "******", " . "password = "******", " . "orders_path = " . invalue('form_orders_path') . ", " . "results_path = " . invalue('form_results_path') . ", " . "notes = " . invalue('form_notes'); if ($ppid) { $query = "UPDATE procedure_providers SET {$sets} " . "WHERE ppid = '" . add_escape_custom($ppid) . "'"; sqlStatement($query); } else { $ppid = sqlInsert("INSERT INTO procedure_providers SET {$sets}"); } } else { if ($_POST['form_delete']) { if ($ppid) { sqlStatement("DELETE FROM procedure_providers WHERE ppid = ?", array($ppid)); } } } if ($_POST['form_save'] || $_POST['form_delete']) { // Close this window and redisplay the updated list.
function cbcell($name, $desc, $colname) { return "<td width='25%' nowrap>" . cbinput($name, $colname) . "{$desc}</td>\n"; } $formid = $_GET['id']; // If Save was clicked, save the info. // if ($_POST['bn_save']) { $fiinjmin = (int) $_POST['form_injmin']; // If updating an existing form... // if ($formid) { $query = "UPDATE form_football_injury_audit SET " . "fiinjmin = " . invalue('form_injmin') . ", " . "fiinjtime = " . rbvalue('form_injtime') . ", " . "fimatchtype = " . rbvalue('form_matchtype') . ", " . "fimech_tackling = " . cbvalue('form_mech_tackling') . ", " . "fimech_tackled = " . cbvalue('form_mech_tackled') . ", " . "fimech_collision = " . cbvalue('form_mech_collision') . ", " . "fimech_kicked = " . cbvalue('form_mech_kicked') . ", " . "fimech_elbow = " . cbvalue('form_mech_elbow') . ", " . "fimech_nofoul = " . cbvalue('form_mech_nofoul') . ", " . "fimech_oppfoul = " . cbvalue('form_mech_oppfoul') . ", " . "fimech_ownfoul = " . cbvalue('form_mech_ownfoul') . ", " . "fimech_yellow = " . cbvalue('form_mech_yellow') . ", " . "fimech_red = " . cbvalue('form_mech_red') . ", " . "fimech_passing = " . cbvalue('form_mech_passing') . ", " . "fimech_shooting = " . cbvalue('form_mech_shooting') . ", " . "fimech_running = " . cbvalue('form_mech_running') . ", " . "fimech_dribbling = " . cbvalue('form_mech_dribbling') . ", " . "fimech_heading = " . cbvalue('form_mech_heading') . ", " . "fimech_jumping = " . cbvalue('form_mech_jumping') . ", " . "fimech_landing = " . cbvalue('form_mech_landing') . ", " . "fimech_fall = " . cbvalue('form_mech_fall') . ", " . "fimech_stretching = " . cbvalue('form_mech_stretching') . ", " . "fimech_turning = " . cbvalue('form_mech_turning') . ", " . "fimech_throwing = " . cbvalue('form_mech_throwing') . ", " . "fimech_diving = " . cbvalue('form_mech_diving') . ", " . "fimech_overuse = " . cbvalue('form_mech_overuse') . ", " . "fimech_othercon = " . txvalue('form_mech_othercon') . ", " . "fimech_othernon = " . txvalue('form_mech_othernon') . ", " . "fisurface = " . rbvalue('form_surface') . ", " . "fiposition = " . rbvalue('form_position') . ", " . "fifootwear = " . rbvalue('form_footwear') . ", " . "fiside = " . rbvalue('form_side') . ", " . "firemoved = " . rbvalue('form_removed') . " " . "WHERE id = '{$formid}'"; sqlStatement($query); } else { $query = "INSERT INTO form_football_injury_audit ( " . "fiinjmin, fiinjtime, fimatchtype, " . "fimech_tackling, fimech_tackled, fimech_collision, " . "fimech_kicked, fimech_elbow, fimech_nofoul, fimech_oppfoul, " . "fimech_ownfoul, fimech_yellow, fimech_red, fimech_passing, " . "fimech_shooting, fimech_running, fimech_dribbling, fimech_heading, " . "fimech_jumping, fimech_landing, fimech_fall, fimech_stretching, " . "fimech_turning, fimech_throwing, fimech_diving, fimech_overuse, " . "fimech_othercon, fimech_othernon, fisurface, fiposition, fifootwear, " . "fiside, firemoved " . ") VALUES ( " . invalue('form_injmin') . ", " . rbvalue('form_injtime') . ", " . rbvalue('form_matchtype') . ", " . cbvalue('form_mech_tackling') . ", " . cbvalue('form_mech_tackled') . ", " . cbvalue('form_mech_collision') . ", " . cbvalue('form_mech_kicked') . ", " . cbvalue('form_mech_elbow') . ", " . cbvalue('form_mech_nofoul') . ", " . cbvalue('form_mech_oppfoul') . ", " . cbvalue('form_mech_ownfoul') . ", " . cbvalue('form_mech_yellow') . ", " . cbvalue('form_mech_red') . ", " . cbvalue('form_mech_passing') . ", " . cbvalue('form_mech_shooting') . ", " . cbvalue('form_mech_running') . ", " . cbvalue('form_mech_dribbling') . ", " . cbvalue('form_mech_heading') . ", " . cbvalue('form_mech_jumping') . ", " . cbvalue('form_mech_landing') . ", " . cbvalue('form_mech_fall') . ", " . cbvalue('form_mech_stretching') . ", " . cbvalue('form_mech_turning') . ", " . cbvalue('form_mech_throwing') . ", " . cbvalue('form_mech_diving') . ", " . cbvalue('form_mech_overuse') . ", " . txvalue('form_mech_othercon') . ", " . txvalue('form_mech_othernon') . ", " . rbvalue('form_surface') . ", " . rbvalue('form_position') . ", " . rbvalue('form_footwear') . ", " . rbvalue('form_side') . ", " . rbvalue('form_removed') . " " . ")"; $newid = sqlInsert($query); addForm($encounter, "Football Injury Audit", $newid, "football_injury_audit", $pid, $userauthorized); } formHeader("Redirecting...."); formJump(); formFooter(); exit; } if ($formid) { $row = sqlQuery("SELECT * FROM form_football_injury_audit WHERE " . "id = '{$formid}' AND activity = '1'"); } ?> <html> <head> <?php
function issue_football_injury_save($issue) { $query = "REPLACE INTO lists_football_injury ( " . "id, fiinjmin, fiinjtime, fimatchtype, " . "fimech_tackling, fimech_tackled, fimech_collision, " . "fimech_kicked, fimech_elbow, fimech_nofoul, fimech_oppfoul, " . "fimech_ownfoul, fimech_yellow, fimech_red, fimech_passing, " . "fimech_shooting, fimech_running, fimech_dribbling, fimech_heading, " . "fimech_jumping, fimech_landing, fimech_fall, fimech_stretching, " . "fimech_turning, fimech_throwing, fimech_diving, fimech_overuse, " . "fimech_othercon, fimech_othernon, fisurface, fiposition, fifootwear, " . "fiside, firemoved " . ") VALUES ( " . $issue . ", " . invalue('form_injmin') . ", " . rbvalue('form_injtime') . ", " . rbvalue('form_matchtype') . ", " . cbvalue('form_mech_tackling') . ", " . cbvalue('form_mech_tackled') . ", " . cbvalue('form_mech_collision') . ", " . cbvalue('form_mech_kicked') . ", " . cbvalue('form_mech_elbow') . ", " . cbvalue('form_mech_nofoul') . ", " . cbvalue('form_mech_oppfoul') . ", " . cbvalue('form_mech_ownfoul') . ", " . cbvalue('form_mech_yellow') . ", " . cbvalue('form_mech_red') . ", " . cbvalue('form_mech_passing') . ", " . cbvalue('form_mech_shooting') . ", " . cbvalue('form_mech_running') . ", " . cbvalue('form_mech_dribbling') . ", " . cbvalue('form_mech_heading') . ", " . cbvalue('form_mech_jumping') . ", " . cbvalue('form_mech_landing') . ", " . cbvalue('form_mech_fall') . ", " . cbvalue('form_mech_stretching') . ", " . cbvalue('form_mech_turning') . ", " . cbvalue('form_mech_throwing') . ", " . cbvalue('form_mech_diving') . ", " . cbvalue('form_mech_overuse') . ", " . txvalue('form_mech_othercon') . ", " . txvalue('form_mech_othernon') . ", " . rbvalue('form_surface') . ", " . rbvalue('form_position') . ", " . rbvalue('form_footwear') . ", " . rbvalue('form_side') . ", " . rbvalue('form_removed') . " " . ")"; sqlStatement($query); }