common.php.save

<?php 

//require_once('tcpdf/config/lang/eng.php');
require_once('tcpdf/tcpdf.php');
require_once('reference_interval.php');
// calibration, EQC,Kit,checklist

$reflex='no';

//$GLOBALS['final_stage']=array('verified','released');
$GLOBALS['final_stage']=array('released');

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

/////////////////////////////////////////////
////////////mysql to mysqli//////////////////
/////////////////////////////////////////////

$GLOBALS['link']='';

if(substr(phpversion(),0,1)>=7)
{
	require_once 'new_to_old.php';
}
///////comment upto here to enable older mysql <7
/////////////////////////////////
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

 */
 
//			<li><a href=new_request_barcode_general_option2_OPD.php>New OPD Blood(S,P)</a>

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_barcode_general_option2.php>New General</a>
			<li><a href=new_request_barcode_general_option2_OPD.php>New OPD</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=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>';

	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>	
		</ul>
	<li><a href="#">Report</a>
		<ul>
			<li><a href=print_report.php>Print</a>
			<li><a href=print_report_pdf_A4_ri_last.php>Print-PDF-A4</a>
			<li><a href=print_report_pdf_A4_discontinuous_ri.php>Print(barcode)</a>
		</ul>
	<li><a href="#">Quality</a>
		<ul>
			<li><a href=import_qc.php>Import QC</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=reagent.php>Reagents</a>	
			<li><a href=calibration.php>Calibrations</a>
			<li><a href=TAT.php>Turnaround time</a>			
		</ul>
	<li><a href="#">Documents/Records</a>
			<ul>
				<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=docs>Docs Upload</a>
				<li><a href="monthly_sample_id_change.php">update sample_id</a>
				<li><a href=print_label_48.php>Print 48 lables</a></li>
				<li><a href=print_lables.php>Print barcode labels</a></li>	
				<li><a href=new_request.php>New</a>
				<li><a href=new_request_FS.php>New Copy[F-S]</a>
				<li><a href=release.php>Release</a>

			</ul>
	
	<li><a href="schedule.php">Reminders</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 id="fld" '.$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='',$status_change='no')
{
	$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' || $key=='released_by' ||$key=='released_at')
		{
			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>';
		}
		elseif($key=='status' && $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>';}
		}
	}