ESH/oxygen_cylinder_details_script.php

<?php  
include ('includes/config/config.php');
include ('includes/auth/auth.php');
include ('includes/functions.php');
include ('access.php');
error_reporting ( E_ERROR | E_PARSE );
?>
<?php  
begin();
// Connect to mysqli database
$page = 1; // The current page
$sortname = 'cylinder_number'; // Sort column
$sortorder = 'desc'; // Sort order
$qtype = ''; // Search column
$query = ''; // Search string
   $searchSql="";          // Get posted data
if (isset ( $_POST ['page'] )) {
	$page = mysqli_real_escape_string($conn,$_POST ['page'] );
}
if (isset ( $_POST ['sortname'] )) {
	$sortname = mysqli_real_escape_string($conn,$_POST ['sortname'] );
}
if (isset ( $_POST ['sortorder'] )) {
	$sortorder = mysqli_real_escape_string($conn,$_POST ['sortorder'] );
}
if (isset ( $_POST ['qtype'] )) {
	$qtype = mysqli_real_escape_string($conn,$_POST ['qtype'] );
}
if (isset ( $_POST ['query'] )) {
	$query = mysqli_real_escape_string($conn,$_POST ['query'] );
}
if (isset ( $_POST ['rp'] )) {
	$rp = mysqli_real_escape_string($conn,$_POST ['rp'] );
}

$hasReadAccess = isAccessible ( $_SESSION ['RoleId'], $menu_key, 'R' );
$hasWriteAccess = isAccessible ( $_SESSION ['RoleId'], $menu_key, 'W' );
$hasExecuteAccess = isAccessible ( $_SESSION ['RoleId'], $menu_key, 'E' );

if($qtype=='cylinder_number'){
	$searchSql = ($qtype != '' && $query != '') ? "where upper($qtype) like upper('%" . trim ( $query ) . "%')" : '';
}
elseif($qtype=='exp_date'){
	$searchSql =  " where date_format(date(exp_date),'%Y-%m-%d')=str_to_date('$query','%d/%m/%Y') ";
}
elseif($qtype=='size'){
	$searchSql = ($qtype != '' && $query != '') ? "where upper($qtype) like upper('%" . trim ( $query ) . "%')" : '';
}

elseif($qtype=='location'){
	$searchSql = ($qtype != '' && $query != '') ? "where upper($qtype) like upper('%" . trim ( $query ) . "%')" : '';
}
else{
	$searchSql = ($qtype != '' && $query != '') ? "where upper($qtype) like upper('%" . trim ( $query ) . "%')" : '';
	
}
//echo $searchSql;
//echo $qtype."  ".$query;
//echo ($qtype != '' && $query != '');

// Setup sort and search SQL using posted data
$sortSql = "order by $sortname $sortorder";


//echo "h".$searchSql;
//$searchSql = preg_replace ( '/and/', 'where', $searchSql, 1 );
// Get total count of records
$sql = "select count(*) from oxygen_cylinder_details $searchSql";
//echo $sql;
$result = mysqli_query ($conn,$sql );
rollback();
$row = mysqli_fetch_array ( $result );
$total = $row [0];
if (! isSet ( $rp )) {
	$rp = 10;
}
// Setup paging SQL
// $rp=1;
$pageStart = ($page - 1) * $rp;
$limitSql = "limit $pageStart, $rp";
// Return JSON data
$data = array ();
$data ['page'] = $page;
$data ['total'] = $total;
$data ['rows'] = array ();
//$sql_ambulance = "SELECT *  FROM ambulance_details    $searchSql $sortSql $limitSql";
$sql_ambulance = "SELECT * FROM oxygen_cylinder_details $searchSql $sortSql $limitSql";
$sql_export=$sql_ambulance;
error_log("scscxsc".$sql_ambulance);
$results_ambulance = mysqli_query($conn,$sql_ambulance);
rollback();
$count = ($page - 1) * $rp + 1;
// echo $sql_ailment;
// echo $access_level;

while ( $row1 = mysqli_fetch_assoc ( $results_ambulance ) ) {
	
	$id= $row1 ['oxygen_cylinder_id'];
	$cylinder_no = getTableFieldValue('oxygen_cylinder','oxygen_kit_no','id',$row1['oxygen_kit_id']);
	$checked_by = getTableFieldValue('patient_master','patient_name','id',$row1['checked_by']);
	$dept_pers = getTableFieldValue('patient_master','patient_name','id',$row1['department_personnel']);
	
	// echo $Department_id;
	$view_link = "";
	$edit_link = "";
	$delete_link = "";
	$links = "";
	if ($hasReadAccess) {
		// echo "shubham";
		$view_link = "<a  href=\"#\"class=\"green\"  onclick=\"open_oxygen_form('".$id."','V');\"><i class=\"ace-icon fa fa-search-plus bigger-130\"></i></a>";
	}
	
	if ($hasWriteAccess) {
		$edit_link = "<a href=\"#\" class=\"blue\" onclick=\"open_oxygen_form('".$id."','E');\"><i class=\"ace-icon fa fa-pencil bigger-130\"></i></a>";
	}
	if ($hasExecuteAccess) {
		$delete_link = "<a href=\"#\" class=\"blue\" onclick=\"delete_oxygen_form('" .$id. "');\"><i class=\"ace-icon fa fa-trash-o bigger-130\"></i></a>";
	}
	$space = "&nbsp;&nbsp;&nbsp;";
	$links = $assign_link . $space . $view_link . $space . $edit_link . $space . $delete_link;
	//$waste_category_name = getTableFieldValue ( 'waste_category', 'waste_category_name', 'waste_category_id', $row1['waste_category'] );
	//$ohc_type_name = getTableFieldValue ( 'ohc_type ', 'ohc_type_name', 'ohc_type_id ', $row1['ohc_type_id '] );
	
	$data ['rows'] [] = array (
			'id' => $row1 ['oxygen_cylinder_id'],
			'cell' => array (
			        $links, 
					$count ++,
					$cylinder_no,
					date_format ( date_create ( $row1 ['issued_date'] ), "d-M-Y" ),
					$row1['reading'],
					$row1['knob_condition'],
					$row1['regulator_key_knob_condition'],
					$checked_by,
					$dept_pers,
					$row1['remarks']
					
					
					
			) 
	);
}

commit();
$data['rows'][] = array(
		'id' => $row['filterkey'],
		'cell' => array('', "<input type=hidden name='filterkey' id='filterkey' value=\"".base64_encode($sql_export)."\">", "<input type=hidden name=paramlist id=paramlist value=\"".($qtype.':'.$query)."\">", '',  '','', '', '', '', '',  '', '', '','', '', '','', '', '','')
);
echo json_encode($data);
?>