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);
}
