$link = start_nchsls(); if (!($search_result = mysql_query($search_str, $link))) { echo mysql_error(); } echo '<form method=post>'; echo '<table border=1 bgcolor=lightblue>'; echo '<tr><td><input type=submit name=critical value=save></td></tr>'; while ($ar = mysql_fetch_assoc($search_result)) { prompt_critical_reportable($ar['sample_id']); } echo '</table>'; echo '</form>'; } else { echo '<h1>No coditions are given for selecting records</h1>'; } /* [critical] => save [result_1005_102907] => 2012-10-09 09:25:30=>root=>TO_XYZ [result_1005_102922] => 2012-10-09 09:25:05=>root=>TO_XYZ [result_1005_102934] => 2012-09-27 16:50:01=>root=>Not Done [result_1005_102952] => 2012-10-09 09:25:05=>root=>TO_XYZ */ if (isset($_POST['critical'])) { foreach ($_POST as $key => $value) { if ($key != 'critical') { $expl = explode('_', $key); save_single_examination($expl[2], $expl[1], $value); echo $key . '=>' . $value . '<br>'; } } }
function update_cross_reference($sample_id) { $sql = 'select * from attachment where sample_id=\'' . $sample_id . '\''; //echo $sql; $link = start_nchsls(); if (!($result = mysql_query($sql, $link))) { return FALSE; } $str = ''; while ($array = mysql_fetch_assoc($result)) { $str = $str . ',' . $array['attachment_id']; } insert_single_examination($sample_id, 1008); save_single_examination($sample_id, 1008, $str); }
function check_critical_reporting($sample_id) { insert_single_examination($sample_id, 1005); $result = get_examination_result_id(1005, $sample_id); if (strlen($result == 0)) { save_single_examination($sample_id, 1005, strftime('%Y-%m-%d %H:%M:%S') . '=>' . $_SESSION['login'] . '=>TO_XYZ'); return 8; //incomplate reporting } else { if (substr($result, -6, 6) != 'TO_XYZ') { return 0; } else { save_single_examination($sample_id, 1005, strftime('%Y-%m-%d %H:%M:%S') . '=>' . $_SESSION['login'] . '=>TO_XYZ'); return 8; //incomplate reporting } } }