function group_edit()
{
echo '<table border=1 bgcolor=lightgreen><form method=post>';
echo '<tr><td>';
mk_select_from_sql('desc reagent', 'Field', '', '');
echo '</td><tr><td>';
echo '<input type=text name=\'value\' ></td></tr>';
echo '<tr><td bgcolor=yellow><input type=submit name=submit value=group_edit>';
echo '</td></tr></table></form>';
}
function read_seat($link)
{
echo '<form method=post>';
$sql = 'select id, concat_ws("-",id,subject,location) display from subloc';
$display = 'display';
$real = 'id';
mk_select_from_sql($link, $sql, 'id', $display, $real, '', '');
mk_select_from_sql($link, 'select catagory from catagory', 'catagory', 'catagory', 'catagory', '', '');
$num = array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15);
mk_select_from_array_return_value('max_number', $num, '', '');
echo '<input type=submit name=save_seat value=\'add seat\'>';
echo '</form>';
}
function new_equipment_record()
{
echo '<table border=1> <form method=post>';
echo '<tr>';
echo '<tr><th colspan=5>New equipment_record</th></tr>';
echo '<tr><td>date</td><td>';
echo '<input readonly id=date class="datepicker" size="10" name=date value=\'' . date('Y-m-d') . '\'>';
echo '</td><td>Date of recording</td></tr>';
echo '<tr><td>Equipment</td><td>';
mk_select_from_sql('select equipment from equipment', 'equipment', '', '');
echo '</td><td>Select Equipment for which record is made</td></tr>';
echo '<tr><td>Record Type</td><td>';
mk_select_from_sql('select equipment_record_type from equipment_record_type', 'equipment_record_type', '', '');
echo '</td><td>Select type of record</td></tr>';
echo '<tr><td>Description</td><td><textarea name=description></textarea></td><td>Write observation/action taken</td></tr>';
echo '<tr><td>Attachment</td><td>Edit after Save</td>';
echo '</td><td>Location of detailed report</td></tr>';
echo '<tr><td><button type=submit name=action value=save_new_equipment_record>save</button></td></tr>';
echo '</form></table>';
view_data_sql('select * from equipment_record_type');
}
echo '<tr><td>' . $array_qc['code'] . '</td><td>' . round($array_qc['Target_100'] - 100, 1) . '</td><td>' . $array_qc['CV'] . '</td></tr>';
}
}
/*
while($array_qc=mysql_fetch_assoc($result_qc))
{
echo '<tr><td>'.$array_qc['code'].'</td><td>'.$array_qc['SD_100'].'</td><td>'.$array_qc['Target_100'].'</td><td>'.$array_qc['CV'].'</td></tr>';
}*/
}
echo '<table>';
echo '<th><h1>Monthly QC data Biochemistry, NCHSLS, NCH, Surat</h1></th>';
echo '<form method=post action=get_monthly_qc_data.php>';
echo '<tr><td>Write YYMM</td></tr>';
echo '<tr><td><input type=text name=YYMM_selected></td></tr>';
echo '<tr><td>';
mk_select_from_sql('select equipment_name from qc_equipment', 'equipment_name', '', '');
echo '</td></tr>';
echo '<tr><td><input type=submit value=OK name=submit></td></tr>';
echo '</form>';
echo '</table>';
echo '<h2 style="page-break-before: always;"></h2>';
if (isset($_POST['YYMM_selected'])) {
echo '<table border="1" bgcolor=lightgreen>
<tr bgcolor=lightblue><td colspan=2>' . $_POST['equipment_name'] . '</td><td colspan=2>YYMM=' . $_POST['YYMM_selected'] . '</td></tr>';
get_qc_data($_POST['equipment_name'], $_POST['YYMM_selected']);
echo '<tr><th colspan=7 bgcolor=lightblue>Yearly Data</th></tr>';
get_qc_data_yearly($_POST['equipment_name'], $_POST['YYMM_selected']);
echo '</table>';
}
//echo '<pre>';
//print_r($GLOBALS);
read_date_time(4);
echo '</td>';
echo '<td>Select:
</td><td>
<select name=period>
<option name=select_year>Year</option>
<option selected name=select_month>Month</option>
<option name=select_day>Day</option>
<option name=select_hour>Hour</option>
</select>
</td></tr>';
echo ' </tr><td>Equipment:</td><td colspan=10>';
mk_select_from_sql('select equipment_name from qc_equipment', 'equipment_name', '', '');
echo ' <td></tr>';
echo ' </tr><td>Examination:';
mk_select_from_sql('select distinct code from qc_target', 'code', '', '');
if (isset($_POST['all_examinations'])) {
echo ' </td><td>All Examinations:<input type=checkbox checked name=all_examinations></tr>';
} else {
echo ' </td><td>All Examinations:<input type=checkbox name=all_examinations></tr>';
}
echo ' <tr>
<td bgcolor=lightpink><input type=submit name=submit value=show_LJ></td>
</tr>
<tr>
<td bgcolor=lightblue><input type=submit name=submit value=insert_qc></td>
<td bgcolor=lightblue colspan=2>QC-normal:<input type=text name=qc_normal></td>
<td bgcolor=lightblue colspan=2 >QC-abnormal:<input type=text name=qc_abnormal></td>
</tr>';
echo '</form>';
echo '</table>';
