common.php.save.1

<?php 


// calibration, EQC,Kit,checklist

$reflex='yes';
					//if 'no'=>it will bypass reflex testing
date_default_timezone_set('Asia/Kolkata');

/////////////////////////////////
function login_varify()
{
return mysql_connect('127.0.0.1',$_SESSION['login'],$_SESSION['password']);
}

/////////////////////////////////
function select_nchsls($link)
{
	return mysql_select_db('biochemistry',$link);
}

///////////////////////////////////
function start_nchsls()
{
	if(!$link=login_varify())
	{
		exit();
	}


	if(!select_nchsls($link))
	{
		exit();
	}
return $link;
}

function my_mysql_query($sql,$link)
{
	if(strpos($sql,'update')>=0 || strpos($sql,'delete')>=0||strpos($sql,'insert'>=0))
	{
		$log='insert into log values(\'\',sysdate(),current_user(),\''.mysql_real_escape_string($sql,$link).'\')';
		//echo $log;
		mysql_query($log,$link);
	}
	return mysql_query($sql,$link);
}

/*

select resident in charge
grant previlages and create users

TAT- sample and exam wise OK
EQA-data and comment      
Monthly summary
calibration data
kit management-batch management
complain,feedback
repeat-batch to know pending, not-entered receipt, not-run sample
printed-dispatched

 */
function main_menu()
{
	echo '<link rel="stylesheet" type="text/css" href="horizontal.css">
	<script type="text/javascript" href=menu.js></script>
	<table border=0><tr><td>
	<div id="navbar">
	<ul>
	<li><a href="#">New</a>
		<ul>
			<li><a href=new_request.php>New</a>
			<li><a href=new_request_FS.php>New Copy[F-S]</a>
			<li><a href=new_request_barcode.php>New barcode</a>
		</ul>
	<li><a href="#">Edit</a>
		<ul>
			<li><a href=edit_request.php>Edit</a>
			<li><a href=delete_sample_request.php>Delete Sample</a>
			<li><a href=delete_examination_request.php>Delete Examination</a>
			<li><a href=attachment.php>Manage Attachment</a>
		</ul>
	<li><a href="#">Worklist</a>
		<ul>
			<li><a href=1_by_1.php>1-by-1</a>
			<li><a href=send_sample_to_XL_640.php>Send to XL-640</a>
			<li><a href=manage_barcoded_batch_of_XL_640.php>Manage Barcoded Batch of XL-640</a>
			<li><a href=send_sample_to_miura.php>Send to Miura-300</a>
			<li><a href=examination_wise_worklist.php>Examination wise worklist</a>
			<li><a href=sample_wise_worklist.php>Sample wise worklist</a>
		</ul>
	<li><a href="#">Result</a>
		<ul>
			<li><a href=import_results_XL_640.php>Import from Erba XL-640</a>';

//comment below this when autoverification needs to be turned off	
//<li><a href=print_report_pdf.php>Print-PDF-A5</a>		
	echo '	<li><a href=import_autoverify_results_XL_640.php>Import-cum-autoverify Erba XL-640</a>
			<li><a href=autoverify.php>Autoverify 1-by-1</a>
			<li><a href=search_autoverify.php>Search-cum-Autoverify</a>';
			
	echo '	<li><a href=critical_report.php>Critical Report</a>
			<li><a href=examination_wise_results.php>Examination wise Entry</a>	
			<li><a href=import_results_miura.php>Import from Miura-300</a>
		</ul>
	<li><a href="#">Report</a>
		<ul>
			<li><a href=print_report.php>Print</a>		
				
			<li><a href=print_report_pdf_A4.php>Print-PDF-A4</a>

		</ul>
	<li><a href="#">Quality</a>
		<ul>
			<li><a href=import_qc.php>Import QC</a>
			<li><a href=repeat_check.php>Repeat Check</a>
			<li><a href=lj_chart.php>LJ chart/ insert/comment QC</a>
			<li><a href=refrigerator_temperature.php>Refrigerator Temperatures</a>
			<li><a href=environmental_parameter.php>Environmental Parameter</a>
			<li><a href=equipment_log.php>Equipment Log</a>
			<li><a href=equipment_record.php>Equipment Record</a>
			<li><a href=nc.php>Nonconformity Records</a>
			<li><a href=consumable.php>Inventory Records</a>
			<li><a href=reagent.php>Reagents</a>
			<li><a href=print_label_48.php>Print 48 lables</a></li>
			<li><a href=calibration.php>Calibrations</a>
			<li><a href=get_monthly_qc_data.php>Monthly QC Records</a>
		</ul>
	<li><a href="#">Documents/Records</a>
			<ul>
				<li><a target=_blank href="NCHSLS/c/001 Biochemistry/Documents/Internal Documents/BI 0015 Standard Oprating Procedures Manual/SOP">SOP</a>		
				<li><a target=_blank href=view_scope.php>Scope</a></li>
				<li><a href=view_data.php>View (from database)</a>
				<li><a href=NCHSLS target="_blank">View(from file system)</a>
				<li><a href=upload.php>Upload</a>
				<li><a href="monthly_sample_id_change.php">update sample_id</a>
				<li><a href=letter.php>Letter</a>
				<li><a href="NCHSLS/c/001%20Biochemistry/Documents/Internal%20Documents/BI%200026%20Physical%20copy%20of%20online%20LIS%20user-manual/BI%200025%20Physical%20copy%20of%20online%20LIS%20user-manual.pdf">User Manual</a>
			</ul>
	
	<li><a href="schedule.php">Reminders('.count_cron().')</a>

	<li><a href="#">'.$_SESSION['login'].'</a>
			<ul>
				<li><a href="logout.php">Logout</a>
				<li><a href="change_password.php">Change Password</a>
				<li><a href="mlamp.php" target=_blank>About</a>	
				<li><a href="suggestion.php" target=_blank>Suggestion</a>
			</ul>
	</ul></div>

	</td></tr></table>';
}

function mk_select_from_table($field,$disabled,$default)
{
	$link=start_nchsls();
	//$sql='select * from '.$field;
	$sql='select `'.$field.'` from '.$field;
	if(!$result=mysql_query($sql,$link)){return FALSE;}
	
		echo '<select  '.$disabled.' name='.$field.'>';
		while($result_array=mysql_fetch_assoc($result))
		{
		if($result_array[$field]==$default)
		{
			echo '<option selected  > '.$result_array[$field].' </option>';
		}
		else
			{
				echo '<option  > '.$result_array[$field].' </option>';
			}
		}
		echo '</select>';	
		return TRUE;
}

function mk_select_from_sql($sql,$name,$disabled,$default)
{
	$link=start_nchsls();
	if(!$result=mysql_query($sql,$link)){return FALSE;}
	
		echo '<select  '.$disabled.' name='.$name.'>';
		while($result_array=mysql_fetch_assoc($result))
		{
		if($result_array[$name]==$default)
		{
			echo '<option selected  > '.$result_array[$name].' </option>';
		}
		else
			{
				echo '<option  > '.$result_array[$name].' </option>';
			}
		}
		echo '</select>';	
		return TRUE;
}


function mk_select_from_array_return_key($name, $select_array,$disabled,$default)
{
		echo '<select  '.$disabled.' name='.$name.'>';
		foreach($select_array as $key=>$value)
		{
		if($value==$default)
		{
			echo '<option selected value=\''.$key.'\' > '.$value.' </option>';
		}
		else
			{
				echo '<option  value=\''.$key.'\' > '.$value.' </option>';
			}
		}
		echo '</select>';	
		return TRUE;
}

function mk_select_from_array_return_value($name, $select_array,$disabled,$default)
{
		echo '<select  '.$disabled.' name='.$name.'>';
		foreach($select_array as $key=>$value)
		{
		if($value==$default)
		{
			echo '<option selected value=\''.$value.'\' > '.$value.' </option>';
		}
		else
			{
				echo '<option  value=\''.$value.'\' > '.$value.' </option>';
			}
		}
		echo '</select>';	
		return TRUE;
}

function edit_sample($sample_id,$filename,$disabled,$type_preservative_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') && $type_preservative_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;
}


function save_sample($post_array)
{
	$link=start_nchsls();
	$sql='update sample set ';
		foreach ($post_array as $key => $value)
		{
			if($key!='action')
			{		
			$sql=$sql.' '.$key.'=\''.$value.'\' , ';
			}
		}

	$sql=substr($sql,0,-2);
	$sql=$sql.' where sample_id= \''.$post_array['sample_id'].'\'';
	//echo $sql;

	if(!mysql_query($sql,$link)){echo mysql_error(); return FALSE;}
	return TRUE;
}

function change_sample_status($sample_id,$str)
{
	$link=start_nchsls();
	$sql='update sample set status=\''.$str.'\' where sample_id=\''.$sample_id.'\'';
	if(!mysql_query($sql,$link)){echo mysql_error(); return FALSE;}
	return TRUE;
}


function sample_printed($sample_id_array)
{
	$link=start_nchsls();
	foreach($sample_id_array as $sample_id)
	{
		$sql='update sample set details=\'printed\' where sample_id=\''.$sample_id.'\'';
		if(!mysql_query($sql,$link)){echo mysql_error();}
	}
}
function save_sample_FS($copy_sample_id,$paste_sample_id)
{
$link=start_nchsls();

$csql='select * from sample where sample_id=\''.$copy_sample_id.'\'';
$cresult=mysql_query($csql,$link);
if(mysql_num_rows($cresult)!=1)
{
	echo 'from_sample_id do not exist<br>';
	return;
}
$ar=mysql_fetch_assoc($cresult);

$sql='update sample set ';

	foreach ($ar as $key => $value)
	{
		if($key=='sample_id')
		{
			$sql=$sql.' '.$key.'=\''.$paste_sample_id.'\' , ';
		}
		else if($key=='preservative' && $value=='None')
		{
			$sql=$sql.' '.$key.'=\''.'Fluoride'.'\' , ';
		}
		else if($key=='preservative' && $value=='Fluoride')
		{
			$sql=$sql.' '.$key.'=\''.'None'.'\' , ';
		}
		else
		{
			$sql=$sql.' '.$key.'=\''.$value.'\' , ';	
		}
	}

$sql=substr($sql,0,-2);
$sql=$sql.' where sample_id= \''.$paste_sample_id.'\'';
//echo $sql;

if(!mysql_query($sql,$link)){echo mysql_error();}
}


function select_profile($sample_id,$filename)
{
	$link=start_nchsls();
	$sql_sample_data='select sample_type,preservative 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);

	$sql='select * from profile where (sample_type=\''.$sample_array['sample_type'].'\' and preservative=\''.$sample_array['preservative'].'\') or profile like \'Z_%\' ';

	$result=mysql_query($sql,$link);

	echo '<form method=post action=\''.$filename.'\'>';
	echo '<table border=1 bgcolor=lightyellow CELLPADDING=0 CELLSPACING=0 >	
			<tr><th colspan=8 align=left>Profiles</th>';
	echo '<th nowrap><input type=hidden name=sample_id value=\''.$sample_id. '\'> </th>';
	$counter=0;
	echo '</tr><tr>';
	echo '<input type=hidden name=action value=profile></td>';
	while($ar=mysql_fetch_assoc($result))
	{
		foreach ($ar as $key => $value)
		{		if($key=='profile')
				{
					echo '<td nowrap><button type=submit name=profile value=\''.$value.'\'>'.$value.'</button></td>';
					$counter++;
				}
				if($counter%5==0){echo '</tr><tr>';}
		}
	}

	echo '</tr></form></table>';
}

function insert_single_examination($sample_id,$id)
	{
		$link=start_nchsls();
		$sql='select * from scope where id=\''.$id.'\'';
		$result=mysql_query($sql,$link);
		$post_array=mysql_fetch_assoc($result);
				
		$sql='insert into examination (`sample_id`, `id`, `name_of_examination`, `sample_type`, `preservative`, `method_of_analysis`, `result`, `unit`, `referance_range`, `code`, `details`,`NABL_Accredited`) 
					values ('.
					'\''.$sample_id.'\' , '.
					'\''.$post_array['id'].'\' , '.
					'\''.$post_array['name_of_examination'].'\' , '.
					'\''.$post_array['sample_type'].'\' , '.
					'\''.$post_array['preservative'].'\' , '.
					'\''.$post_array['method_of_analysis'].'\' , '.
					'\''.$post_array['result'].'\' , '.
					'\''.$post_array['unit'].'\' , '.
					'\''.$post_array['referance_range'].'\' , '.
					'\''.$post_array['code'].'\' , '.
					'\'\' , '.
					'\''.$post_array['NABL_Accredited'].'\' , ';
			$sql=substr($sql,0,-2);
			$sql=$sql.')';
			//echo $sql;
			if(!mysql_query($sql,$link))
			{
				//echo mysql_error();
			}
			else
			{
				return mysql_affected_rows($link);
			}
					
	}


function insert_profile($sample_id,$profile)
{
	$link=start_nchsls();
		$sql='select * from profile where profile=\''.$profile.'\'';
		$result=mysql_query($sql,$link);
		
	while($profile_row=mysql_fetch_assoc($result))
	{
		foreach ($profile_row as $key => $value)   //for every row in profile
		{
			if($key!='profile' && $value!=NULL && $key!='sample_type' && $key!='preservative')
			{
			insert_single_examination($sample_id,$value);
			}
		}
	}
}


function edit_examination($sample_id,$filename,$disabled)
{
	$link=start_nchsls();
	$sql='select * from examination where sample_id=\''.$sample_id.'\'';
	if(!$result=mysql_query($sql,$link)){echo 'No such Sample';return FALSE;}
	if(mysql_num_rows($result)<1){echo 'No examinations';return FALSE;}
	
	echo '<table border=1 bgcolor=lightgrey CELLPADDING=0 CELLSPACING=0>';
	echo '<form method=post action=\''.$filename.'\'>';
	echo '<input type=hidden name=sample_id value=\''.$sample_id.'\'';		  
	echo '<tr><td><input type=submit value=save_examination  '.$disabled.' name=action></td></td><th colspan=18 align=left>Examination Result Entry Form</th></tr>';
	
	$first='true';
	while($ar=mysql_fetch_assoc($result))
	{
		echo '<tr>';
		if($first=='true')
		{
			foreach ($ar as $key => $value)   //for every row in scope
			{
				echo '<th nowrap>'.$key.'</th>';
			}
			$first='false';			
			echo '</tr>';
		}
		if($ar['id']<1000)
		{
			foreach ($ar as $key => $value)   //for every row in scope
			{
					if($key=='result')
					{
						echo '<td nowrap><input type=text '.$disabled.' name=\''.$ar['id'].'\' value=\''.$value.'\'></td>';
					}
					else
					{
						echo '<td nowrap>'.$value.'</td>';
					}
			}
		}
		elseif($ar['id']>=1000)
		{
			foreach ($ar as $key => $value)   //for every row in scope
			{
					if($key=='result')
					{
						echo '<td><b>'.trim($ar['name_of_examination'],'Z_').':</b></td><td colspan=20><input size=80 type=text '.$disabled.' name=\''.$ar['id'].'\' value=\''.$value.'\'></td>';
					}
			}
		}
		echo '</tr>';		
	}
	echo '</form></table>';
}	

/*
array(
action=>save_examination
sample_id=>1234
12=>1.2
34=>34
	)
*/
function save_examination($post_array)
{
	$link=start_nchsls();
	foreach ($post_array as $key => $value)
	{
		if($key!='action')
		{
			$sql='update examination set result=\''.$value.'\' where sample_id=\''.$post_array['sample_id'].'\' and id=\''.$key.'\'';
			if(!mysql_query($sql,$link)){echo mysql_error();}
		}
	}
}

function save_single_examination($sample_id,$examination_id,$result)
{
	$link=start_nchsls();
	$sql='update examination set result=\''.$result.'\' where sample_id=\''.$sample_id.'\' and id=\''.$examination_id.'\'';
	if(!mysql_query($sql,$link)){echo mysql_error();}
}


function save_single_examination_code($sample_id,$code,$result)
{
	$link=start_nchsls();
	$sql='update examination set result=\''.$result.'\' where sample_id=\''.$sample_id.'\' and code=\''.$code.'\'';
	if(!mysql_query($sql,$link)){echo mysql_error();}
}

function append_single_examination($sample_id,$examination_id,$result)
{
	$link=start_nchsls();
	$sql='update examination set result=concat(result,\''.$result.'\') where sample_id=\''.$sample_id.'\' and id=\''.$examination_id.'\'';
	if(!mysql_query($sql,$link)){echo mysql_error();}
}

function select_examination($sample_id,$filename,$disabled)
{
	$link=start_nchsls();
	$sql_sample_data='select sample_type,preservative 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);
	$sql='select * from scope where sample_type=\''.$sample_array['sample_type'].'\' and preservative=\''.$sample_array['preservative'].'\' or name_of_examination like \'Z_%\' order by name_of_examination';
	//echo $sql;
	$result=mysql_query($sql,$link);

	echo '<table border=1 id=\'id\' bgcolor=lightgrey CELLPADDING=0 CELLSPACING=0>';
	echo '<form method=post action=\''.$filename.'\'>';
	echo '<input type=hidden name=sample_id value=\''.$sample_id.'\'';	
	  
	echo '<tr>
			<input type=hidden value=select_examination  '.$disabled.' name=action>
			<th colspan=18 align=left>Scope</th>
		</tr>';
	$first='true';
	while($ar=mysql_fetch_assoc($result))
	{
		if($first=='true')
		{
			foreach ($ar as $key => $value)   //for every row in scope
			{
				echo '<th nowrap>'.$key.'</th>';
			}
			$first='false';			
			
		}
		echo '<tr>';
			foreach ($ar as $key => $value)   //for every row in scope
			{
					if($key=='id')
					{
						echo '<td nowrap><button type=submit '.$disabled.' name=\''.$key.'\' value=\''.$value.'\'>'.$value.'</button></td>';
					}
					else
					{
						echo '<td nowrap>'.$value.'</td>';
					}
			}
		echo '</tr>';		
	}
	echo '</form></table>';

}	

function print_sample_worklist($sample_id)
{
		$link=start_nchsls();
		$sql='select * from examination where sample_id=\''.$sample_id.'\'';
		$result=mysql_query($sql,$link);
		echo '<table border=1 bgcolor=lightblue>';
		echo '<tr><td colspan=2 align=left>-----['.$sample_id.']-----<td>';
		while($post_array=mysql_fetch_assoc($result))
		{
			echo '<tr><td>'.$post_array['name_of_examination'].'</td><td>'.$post_array['code'].'</td><td>'.$post_array['result'].'</td></tr>';
		}
		echo '</table>';
}


///////////////////////autoverify functions

//used to find if result have anything other than 0-9 and .
//even a space in the string means that it is not numeric






function is_str_interger($str)
{
$nm=array('0','1','2','3','4','5','6','7','8','9');

$strr=str_split($str);

	foreach($strr as $key=>$value)
		{
		if(!in_array($value,$nm))
			{
			return FALSE;
			}
		}
return $str;
}
					
function is_str_num($str)
{
$nm=array('0','1','2','3','4','5','6','7','8','9','.');

$strr=str_split($str);

	foreach($strr as $key=>$value)
		{
		if(!in_array($value,$nm))
			{
			return FALSE;
			}
		}
return $str;
}

function is_str_digit($str)
{
$nm=array('0','1','2','3','4','5','6','7','8','9');

$strr=str_split($str);

	foreach($strr as $key=>$value)
		{
		if(!in_array($value,$nm))
			{
			return FALSE;
			}
		}
return $str;
}

function check_critical_abnormal_reportable($sample_id,$code)
{
	$link=start_nchsls();
	$sql_sample_examination='
		SELECT s.sample_id, s.sample_type, e.code, e.result, a.operator o1, a.value ov1, aa.operator o2, aa.value ov2, c.operator c1, c.value cv1, cc.operator c2, cc.value cv2,
		r.operator r1, r.value rv1,rr.operator r2, rr.value rv2
		FROM sample s
		LEFT outer JOIN examination e          ON s.sample_id = e.sample_id
		left outer JOIN abnormal_alert a        ON e.code = a.code      and  a.sample_type = s.sample_type
		LEFT  outer  JOIN abnormal_alert aa ON e.code=aa.code      AND aa.sample_type = s.sample_type AND a.operator <> aa.operator
		LEFT  outer JOIN critical_alert c         ON e.code=c.code       AND c.sample_type = s.sample_type
		LEFT  outer JOIN critical_alert cc       ON e.code=cc.code     AND cc.sample_type = s.sample_type AND c.operator <> cc.operator
		LEFT  outer JOIN reportable_alert r   ON e.code=r.code        and  a.sample_type = s.sample_type
		LEFT  outer JOIN reportable_alert rr  ON e.code=rr.code       and  c.sample_type = rr.sample_type AND r.operator <> rr.operator

		where s.sample_id =\''.$sample_id.'\' and e.code=\''.$code.'\'
		group by e.code';

				
	if(!$result_sample_examination=mysql_query($sql_sample_examination,$link)){echo mysql_error();return -1;}
    
	$dt=mysql_fetch_assoc($result_sample_examination);
	
    if(strlen($dt['result'])<=0)
	{
		return -2;
	}
    elseif(!is_str_num($dt['result']))
    {
        return -3;
    }
    else
    {	



		if($dt['r1']=='less_than')
		{
			if($dt['result']<$dt['rv1']){return 1;}		//absurd low
		}
		if($dt['r2']=='less_than')
		{
			if($dt['result']<$dt['rv2']){return 1;}		//absurd low
		}


		
		if($dt['r1']=='more_than')
		{
			if($dt['result']>$dt['rv1']){return 2;}		//absurd high
		}
		if($dt['r2']=='more_than')
		{
			if($dt['result']>$dt['rv2']){return 2;}		//absurd high
		}
		

		if($dt['c1']=='less_than')
		{
			if($dt['result']<$dt['cv1']){return 3;}		//critical low
		}
		if($dt['c2']=='less_than')
		{
			if($dt['result']<$dt['cv2']){return 3;}		//critical low
		}


		
		if($dt['c1']=='more_than')
		{
			if($dt['result']>$dt['cv1']){return 4;}		//critical high
		}
		if($dt['c2']=='more_than')
		{
			if($dt['result']>$dt['cv2']){return 4;}		//critical high
		}
		
		
		if($dt['o1']=='less_than')
		{
			if($dt['result']<$dt['ov1']){return 5;}		//abnormal low
		}
		if($dt['o2']=='less_than')
		{
			if($dt['result']<$dt['ov2']){return 5;}		//abnormal low
		}


		
		if($dt['o1']=='more_than')
		{
			if($dt['result']>$dt['ov1']){return 6;}		//abnormal high
		}
		if($dt['o2']=='more_than')
		{
			if($dt['result']>$dt['ov2']){return 6;}		//abnormal high
		}
		
		return 0;
		
	}
		
	
}

function get_all_details_of_a_sample($sample_id)
{
	$link=start_nchsls();
	$sql_sample_examination='select 
						*
					from 
						examination
						join sample ON sample.sample_id = examination.sample_id
					where 
						sample.sample_id=\''.$sample_id.'\' ';
	
	if(!$result_sample_examination=mysql_query($sql_sample_examination,$link)){echo mysql_error();return FALSE;}
	while ($array_sample_examination=mysql_fetch_assoc($result_sample_examination))
	{	
		$return_array[]=$array_sample_examination;
	}

		//echo '<pre>';
		//print_r($return_array);
		//echo '</pre>';	
        if(!isset($return_array)){return FALSE;}
		return $return_array;

}


function get_patient_id($sample_id)
{
	$all_details=get_all_details_of_a_sample($sample_id);
	if(substr_compare($all_details[0]['patient_id'],'SUR',0,3)==0)
	{
		return $all_details[0]['patient_id'];
	}
	else
	{
		return FALSE;
	}
}

function get_sample_status($sample_id)
{
	$all_details=get_all_details_of_a_sample($sample_id);
	return $all_details[0]['status'];
}
function get_all_sample_id_from_patient_id($patient_id)
{
	$link=start_nchsls();
		$sql='select sample_id from sample where patient_id=\''.$patient_id.'\' order by sample_receipt_time desc';
		if(!$result=mysql_query($sql,$link)){echo mysql_error();return FALSE;}
		while ($array_sample_id=mysql_fetch_assoc($result))
			{	
				$return_array[]=$array_sample_id['sample_id'];
				
			}

				//echo '<pre>';
				//print_r($return_array);
				//echo '</pre>';	
				return $return_array;
}

function get_all_sample_id_from_sample_id($sample_id)
{
	$patient_id=get_patient_id($sample_id);
	if($patient_id!=FALSE)
	{
		return get_all_sample_id_from_patient_id($patient_id);
	}
	else
	{
		return FALSE;
	}
}

// -2=not requested,  -1=not done
function get_examination_result($code,$sample_id)
{
$all_array=get_all_details_of_a_sample($sample_id);
if($all_array)
{
	foreach($all_array as $key=>$value)
		{
		foreach($value as $keyy=>$valuee)
			{
			if($valuee==$code && $keyy=='code')
				{
					return $value['result'];
				}
			}
		}
}
return FALSE;
}

function get_examination_result_id($id,$sample_id)
{
$all_array=get_all_details_of_a_sample($sample_id);
if($all_array)
{
	foreach($all_array as $key=>$value)
		{
		foreach($value as $keyy=>$valuee)
			{
			if($valuee==$id && $keyy=='id')
				{
					return $value['result'];
				}
			}
		}
}
return FALSE;
}

function get_all_data_of_examination($code,$sample_id)
{
$all_array=get_all_details_of_a_sample($sample_id);
if($all_array)
{
	foreach($all_array as $key=>$value)
		{
			if($value['code']==$code)
			{
				return $value;
			}
		}
}
return FALSE;
}

function get_chronology_of_an_examination($code,$sample_id)
{
$chronology=FALSE;
if($sample_id_array=get_all_sample_id_from_sample_id($sample_id)) //return false if start not with SUR
{
foreach($sample_id_array as $key=>$value)
	{
			$chronology[$value]=get_all_data_of_examination($code,$value);
	}
return $chronology;
}
return FALSE;
}

function print_chronology_of_an_examination($chronology)
{
	if($chronology!=FALSE)
	{	
		foreach($chronology as $sample_id=>$data)
		{
			echo '<tr><td>'.$data['code'].'</td><td>'.$data['result'].'</td><td>'.$data['sample_details'].'</td><td>'.$data['sample_receipt_time'].'</td><td>'.$data['sample_id'].'</td><td>'.$data['patient_id'].'</td><td>'.$data['patient_name'].'</td></tr>';
		}
		
		echo '<tr><td colspan=10 bgcolor=blue></td></tr>';
	}
	else
	{
		echo '<tr><td>MRD number format is wrong. Deltacheck terminated</td></tr>';
				echo '<tr><td colspan=10 bgcolor=blue></td></tr>';
	}
}

function print_chronology_of_a_sample($sample_id)
{
	$all_array=get_all_details_of_a_sample($sample_id);
	if($all_array)																							//all tests
	{
		foreach($all_array as $all_ex_data)
		{
			$data=get_chronology_of_an_examination($all_ex_data['code'],$all_ex_data['sample_id']);
			echo '<table bgcolor=lightgreen border=1>';
				print_chronology_of_an_examination($data);
			echo '</table>';
		}
	
	}
}

function my_array_search($ar,$str)
{
	foreach($ar as $key=>$value)
	{
		if($value==$str)
		{
			return TRUE;
		}
	}
	return FALSE;
}


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

function append_if_not($hay,$sample_id,$examination_id)
{
	$value=get_examination_result_id($examination_id,$sample_id);
	$pos=strpos($value,$hay);
		if($pos===FALSE)
		{
			append_single_examination($sample_id,$examination_id,$hay);
		}
}
function indirect_bilirubin($sample_id)
{
	$tbil=get_examination_result('TBIL',$sample_id);
	$dbil=get_examination_result('DBIL',$sample_id);	
	if($tbil!=FALSE && $dbil!=FALSE)
	{
		if(is_str_num($tbil)!=FALSE && is_str_num($dbil)!=FALSE)
		{
			if($tbil>=$dbil)
			{
				save_single_examination_code($sample_id,'IBIL',$tbil-$dbil);
			}
			else
			{
				if(  (($dbil-$tbil)/$dbil)<0.1	)			//2 and 1.8 1 and 0.9 10 and 9
				{
					save_single_examination_code($sample_id,'IBIL','see remark');
					insert_single_examination($sample_id,1007);
					$str='The majority of bilirubin is conjugated in this patient.';
					append_if_not($str,$sample_id,1007);
				}
				else
				{
					return 11;
				}
			}
		}
	}
}



function lipid_profile($sample_id)
{
	//echo '111';
	$cho=get_examination_result('CHO',$sample_id);
	$choh=get_examination_result('CHOH',$sample_id);
	$chol=get_examination_result('CHOL',$sample_id);
	$chov=get_examination_result('CHOV',$sample_id);
	$tg=get_examination_result('TG',$sample_id);
	
	if($cho!=FALSE && $choh!=FALSE && $tg!=FALSE)  	//they are not null
	{
			//echo '222';
		if 	(is_str_num($cho)!=FALSE && is_str_num($choh)!=FALSE && is_str_num($tg)!=FALSE)	//they are number
		{
				//echo '333';
			if($tg<=400)
			{
					//echo '444';
				save_single_examination_code($sample_id,'CHOV',($tg/5));
				save_single_examination_code($sample_id,'CHOL',$cho - $choh -($tg/5));
			}
			else
			{
					//echo '555';
				save_single_examination_code($sample_id,'CHOV','see remark');
				save_single_examination_code($sample_id,'CHOL','see remark');
				insert_single_examination($sample_id,1007);
				$str='if TG>400 mg/dl then LDL can not be calculated. Direct-LDL assay is advised';
				append_if_not($str,$sample_id,1007);
			}
		}
	}
		//both(TandD) are not done, both are not number, dbil>tbil
}
//4->6
//31->7, 11.14,15,23.,65,
//7->31,11.14.23.., 15 ,65,7
function reflex_testing($sample_id,$examination_id)
{