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);
}
{
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']) {
$fu_timing = $_POST['fu_timing'];
$fu_location = $_POST['fu_location'];
// If updating an existing form...
//
if ($formid) {
$query = "UPDATE form_specialist_notes SET " . "notes = '" . $_POST['form_notes'] . "', " . "followup_required = " . cbvalue('fu_required') . ", " . "followup_timing = '{$fu_timing}'" . ", " . "followup_location = '{$fu_location}'" . " " . "WHERE id = '{$formid}'";
sqlStatement($query);
} else {
$query = "INSERT INTO form_specialist_notes ( " . "notes, followup_required, followup_timing, followup_location " . ") VALUES ( " . "'" . $_POST['form_notes'] . "', " . cbvalue('fu_required') . ", " . "'{$fu_timing}'" . ", " . "'{$fu_location}'" . " " . ")";
$newid = sqlInsert($query);
addForm($encounter, "Specialist Notes", $newid, "specialist_notes", $pid, $userauthorized);
}
formHeader("Redirecting....");
formJump();
formFooter();
exit;
}
if ($formid) {
$row = sqlQuery("SELECT * FROM form_specialist_notes WHERE " . "id = '{$formid}' AND activity = '1'");
}
?>
<html>
<head>
<?php
} else {
if ($_POST['activity'] == '23') {
$simech_other = $_POST['activity_nc_other'];
}
}
$sitreat_other = '';
if ($_POST['treat_10']) {
$sitreat_other = $_POST['treat_other'];
}
// If updating an existing form...
//
if ($formid) {
$query = "UPDATE form_soccer_injury SET " . "siinjtime = '{$siinjtime}', " . "sigametime = " . rbvalue('gameplay') . ", " . "simechanism = " . rbvalue('activity') . ", " . "simech_other = '{$simech_other}', " . "sisurface = " . rbvalue('surface') . ", " . "siposition = " . rbvalue('position') . ", " . "sifootwear = " . rbvalue('footwear') . ", " . "siequip_1 = " . cbvalue('equip_1') . ", " . "siequip_2 = " . cbvalue('equip_2') . ", " . "siequip_3 = " . cbvalue('equip_3') . ", " . "siequip_4 = " . cbvalue('equip_4') . ", " . "siequip_5 = " . cbvalue('equip_5') . ", " . "siequip_6 = " . cbvalue('equip_6') . ", " . "siside = " . rbvalue('side') . ", " . "siremoved = " . rbvalue('removed') . ", " . "sitreat_1 = " . cbvalue('treat_1') . ", " . "sitreat_2 = " . cbvalue('treat_2') . ", " . "sitreat_3 = " . cbvalue('treat_3') . ", " . "sitreat_4 = " . cbvalue('treat_4') . ", " . "sitreat_5 = " . cbvalue('treat_5') . ", " . "sitreat_6 = " . cbvalue('treat_6') . ", " . "sitreat_7 = " . cbvalue('treat_7') . ", " . "sitreat_8 = " . cbvalue('treat_8') . ", " . "sitreat_9 = " . cbvalue('treat_9') . ", " . "sitreat_10 = " . cbvalue('treat_10') . ", " . "sitreat_other = '{$sitreat_other}', " . "sinoreturn = " . cbvalue('noreturn') . " " . "WHERE id = '{$formid}'";
sqlStatement($query);
} else {
$query = "INSERT INTO form_soccer_injury ( " . "siinjtime, sigametime, simechanism, simech_other, sisurface, " . "siposition, sifootwear, " . "siequip_1, siequip_2, siequip_3, siequip_4, siequip_5, siequip_6, " . "siside, siremoved, " . "sitreat_1, sitreat_2, sitreat_3, sitreat_4, sitreat_5, " . "sitreat_6, sitreat_7, sitreat_8, sitreat_9, sitreat_10, " . "sitreat_other, sinoreturn " . ") VALUES ( " . "'{$siinjtime}', " . rbvalue('gameplay') . ", " . rbvalue('activity') . ", " . "'{$simech_other}', " . rbvalue('surface') . ", " . rbvalue('position') . ", " . rbvalue('footwear') . ", " . cbvalue('equip_1') . ", " . cbvalue('equip_2') . ", " . cbvalue('equip_3') . ", " . cbvalue('equip_4') . ", " . cbvalue('equip_5') . ", " . cbvalue('equip_6') . ", " . rbvalue('side') . ", " . rbvalue('removed') . ", " . cbvalue('treat_1') . ", " . cbvalue('treat_2') . ", " . cbvalue('treat_3') . ", " . cbvalue('treat_4') . ", " . cbvalue('treat_5') . ", " . cbvalue('treat_6') . ", " . cbvalue('treat_7') . ", " . cbvalue('treat_8') . ", " . cbvalue('treat_9') . ", " . cbvalue('treat_10') . ", " . "'{$sitreat_other}', " . cbvalue('noreturn') . " " . ")";
$newid = sqlInsert($query);
addForm($encounter, "Football Injury", $newid, "soccer_injury", $pid, $userauthorized);
}
formHeader("Redirecting....");
formJump();
formFooter();
exit;
}
$siinjtime = '';
$siampm = '';
if ($formid) {
$row = sqlQuery("SELECT * FROM form_soccer_injury WHERE " . "id = '{$formid}' AND activity = '1'");
$siinjtime = substr($row['siinjtime'], 0, 5);
$siampm = 'am';
$siinjhour = substr($siinjtime, 0, 2);
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);
}
