function search_form($filename)
{
$link = start_nchsls();
$sql = 'desc sample';
if (!($result = mysql_query($sql, $link))) {
echo mysql_error();
}
$tr = 1;
echo '<table border=1><form action=\'' . $filename . '\' method=post>';
echo ' <tr>
<td colspan=5 title=\'1) Tickmark to include the field for search. 2) Use % as wildcard. e.g. [%esh = Mahesh,Jignesh] [Mahesh%=Mahesh,Maheshbhai, Maheshkumar]\'><input type=submit name=submit value=search_and_autoverify></td></tr>';
while ($ar = mysql_fetch_assoc($result)) {
if ($tr % 3 == 1) {
echo '<tr>';
}
if ($ar['Field'] == 'sample_id') {
echo '<td><input type=checkbox checked name=\'chk_from_' . $ar['Field'] . '\' ></td><td>from_' . $ar['Field'] . '</td>';
echo '<td><input type=text name=\'from_' . $ar['Field'] . '\' ></td>';
echo '<td><input type=checkbox name=\'chk_to_' . $ar['Field'] . '\' ></td><td>to_' . $ar['Field'] . '</td>';
echo '<td><input type=text name=\'to_' . $ar['Field'] . '\' >';
$tr++;
} else {
echo '<td><input type=checkbox name=\'chk_' . $ar['Field'] . '\' ></td><td>' . $ar['Field'] . '</td><td>';
if (!mk_select_from_table($ar['Field'], '', '')) {
echo '<input type=text name=\'' . $ar['Field'] . '\' >';
}
}
echo '</td>';
if ($tr % 3 == 0) {
echo '</tr>';
}
$tr++;
}
echo '</form></table>';
}
function search_form($list_of_sample)
{
echo '<form method=post>';
echo '<table border=1 style="background:lightblue;">';
echo '<tr>';
echo '<th>';
echo 'Enter Sample ID to be printed' . '<br>' . 'one in each line and submit';
echo '</th>';
echo '</tr>';
echo '<tr>';
echo '<td>';
echo '<input autofocus type=number name=sample_id>';
echo '<textarea hidden readonly name=list_of_sample>' . $list_of_sample . '</textarea>';
echo '</td>';
echo '</tr>';
echo '<tr>';
echo '<td>';
echo '<button type=submit name=submit value=add style="font:200% bold black;">Add/Remove Sample</button></td><td>';
echo 'Remove<input type=checkbox name=remove value=yes style="font:200% bold black;">';
echo '</td>';
echo '</tr>';
echo '</form>';
echo '</table>';
echo '<table style="background:lightpink;">';
echo '<form method=post target=_blank>';
echo '<tr>';
echo '<td>';
echo '<textarea readonly rows=15 name=list_of_sample>' . $list_of_sample . '</textarea>';
echo '</td>';
echo '</tr>';
echo '<tr>';
echo '<td>';
mk_select_from_table('authorized_signatory', '', '');
echo '</td></tr><tr><td>';
echo '<button type=submit name=submit value=print style="font:200% bold black;">Print</button>';
echo '</td>';
echo '</tr>';
echo '</table>';
echo '</form>';
}
function edit_sample_barcode($sample_array, $filename)
{
$link = start_nchsls();
$counter = 1;
echo '<form method=post action=\'' . $filename . '\'>';
echo ' <table border=1 bgcolor=lightyellow CELLPADDING=0 CELLSPACING=0>
<tr>
<td>
<button type=submit name=action value=save_sample>save sample</button>
</td>
<th colspan=8 align=left>Sample Entry Form</th></tr>';
/*
year is 14
MRD is 12345678
name is Chagan M Patel
dor is 2014-04-17
age_year is 34
age_month is
age_day is
dob is
id_type is
id is
contact is
department is DENT
unit is 5
location is G0MICU
visit is 1
dov is 2014-04-17
<td></td><td><input type=text name= value=\''.$sample_array[''].'\'></td>
*/
echo ' <tr>
<td>sample_id</td><td><input type=text name=sample_id></td>
<td>patient_id</td><td><input type=text name=patient_id value=\'' . $sample_array['MRD'] . '\'></td>
<td>patient_name</td><td><input type=text name=patient_name value=\'' . $sample_array['name'] . '\'></td>
<td>clinician</td><td>';
mk_select_from_table('clinician', '', get_clinician_from_hmis_code($sample_array['department']));
echo '</td>
</tr>';
echo ' <tr>
<td>unit</td><td><input type=text name=unit value=\'' . $sample_array['unit'] . '\'></td>
<td>location</td><td><input type=text name=location value=\'' . $sample_array['location'] . '\'></td>';
echo '</td>
</tr>';
echo '</form></table>';
return TRUE;
}
function insert_reagent()
{
$link = start_nchsls();
$sql = 'desc reagent';
if (!($result = mysql_query($sql, $link))) {
echo mysql_error();
}
$tr = 1;
echo '<table border=1 bgcolor=lightblue><form method=post>';
echo ' <tr>
<td bgcolor=yellow><input type=submit name=submit value=insert></td></tr>';
while ($ar = mysql_fetch_assoc($result)) {
if ($tr % 3 == 1) {
echo '<tr>';
}
echo '<td>' . $ar['Field'] . '</td><td>';
if (!mk_select_from_table($ar['Field'], '', '') && $ar['Field'] != 'id') {
if ($ar['Field'] != 'serial_number') {
echo '<input type=text name=\'' . $ar['Field'] . '\' >';
} else {
echo 'from:<input type=text name=\'' . $ar['Field'] . '_from\' >';
echo 'to:<input type=text name=\'' . $ar['Field'] . '_to\' >';
}
}
echo '</td>';
if ($tr % 3 == 0) {
echo '</tr>';
}
$tr++;
}
echo '</form></table>';
}
function edit_sample($sample_id, $filename, $disabled, $type_preservative_section_change)
{
$link = start_nchsls();
$counter = 1;
$sql_sample_data = 'select * from sample where sample_id=' . $sample_id;
if (mysql_num_rows($result_sample_data = mysql_query($sql_sample_data, $link)) != 1) {
echo 'No such Sample';
return FALSE;
}
$sample_array = mysql_fetch_assoc($result_sample_data);
echo '<form method=post action=\'' . $filename . '\'>';
echo ' <table border=1 bgcolor=lightyellow CELLPADDING=0 CELLSPACING=0>
<tr>
<td>
<button type=submit name=action ' . $disabled . ' value=save_sample>save sample</button>
</td>
<th colspan=8 align=left>Sample Entry Form</th></tr>';
foreach ($sample_array as $key => $value) {
if ($counter % 4 == 1) {
echo '<tr>';
}
if ($key == 'sample_id') {
echo '<td>' . $key . '</td><td><input type=text readonly value=\'' . $value . '\' name=' . $key . '></td>';
} elseif (($key == 'sample_type' || $key == 'preservative' || $key == 'section') && $type_preservative_section_change == 'no') {
echo '<td>' . $key . '</td><td><input type=text readonly value=\'' . $value . '\' name=' . $key . '></td>';
} else {
echo '<td>' . $key . '</td><td>';
if (!mk_select_from_table($key, $disabled, $value)) {
echo '<input type=text ' . $disabled . ' value=\'' . $value . '\' name=' . $key . '>';
}
echo '</td>';
}
if ($counter % 4 == 0) {
echo '<tr>';
}
$counter++;
}
echo '</form></table>';
return TRUE;
}
