ESH/ambulance_checklist_script.php

<?php 
include ('includes/config/config.php');
include ('includes/auth/auth.php');
include ('includes/functions.php');
include ('access.php');
include('log_entry.php');
error_reporting ( E_ERROR | E_PARSE );
?>
<?php  
begin();
// Connect to mysqli database
$page = 1; // The current page
$sortname = 'ambulance_no'; // 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 ($_POST ['page'] );
}
if (isset ( $_POST ['sortname'] )) {
	$sortname = mysqli_real_escape_string ($_POST ['sortname'] );
}
if (isset ( $_POST ['sortorder'] )) {
	$sortorder = mysqli_real_escape_string ($_POST ['sortorder'] );
}
if (isset ( $_POST ['qtype'] )) {
	$qtype = mysqli_real_escape_string ($_POST ['qtype'] );
}
if (isset ( $_POST ['query'] )) {
	$query = mysqli_real_escape_string ($_POST ['query'] );
}
if (isset ( $_POST ['rp'] )) {
	$rp = mysqli_real_escape_string ($_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=='ambulance_no'){
	$searchSql = ($qtype != '' && $query != '') ? "where upper($qtype) like upper('%" . trim ( $query ) . "%')" : '';
}
else if($qtype=='firstaid_box'){
    $searchSql = ($qtype != '' && $query != '') ? "where upper($qtype) like upper('%" . trim ( $query ) . "%')" : '';
}
else if($qtype==''){
	$searchSql = ($qtype != '' && $query != '') ? "where upper($qtype) like upper('%" . trim ( $query ) . "%')" : '';
}else if($qtype=='oxygen_cylinder'){
	
	$searchSql = ($qtype != '' && $query != '') ? "where date_of_filling($qtype)= '$query' " : '';
}else{
	$searchSql = ($qtype != '' && $query != '') ? "where upper($qtype) like upper('%" . trim ( $query ) . "%')" : '';
	
}
//echo $searchSql;
//echo $qtype."  ".$query;
//echo ($qtype != '' && $query != '');
error_log("search".$searchSql);
// 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 ambulance_checklist ";
error_log("nnnnnnnnnnn".$sql);
//echo $sql;
$result = mysqli_query ($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_checklist";
$sql_export=$sql_ambulance;

error_log("aa".$sql_ambulance);
$results_ambulance = mysqli_query($conn,$sql_ambulance);
rollback();
$count = 1;


while ( $row1 = mysqli_fetch_assoc ( $results_ambulance ) ) {
	
	$checklist_id= $row1 ['checklist_id'];

	error_log("CHECKLIST_ID::".$checklist_id);
	
	$ambulance=$row1['ambulance_id'];
	$box2="select ambulance_name from ambulance_details_new where id='".$ambulance."'";
	
	$result1=mysqli_query($conn,$box2);
	$row3=mysqli_fetch_assoc($result1);

	if($row1['firstaid_box'] == 'P'){
      $firstaid = "PRESENT";
	}
	else{
		$firstaid = "ABSENT";
	}

	if($row1['oxygen_cylinder'] == 'E'){
      $oxygen = "EMPTY";
	}
	else{
		$oxygen = "FILLED";
	}

	if($row1['bedsheet'] == 'C'){
      $bed = "CLEAN";
	}
	else{
		$bed = "DIRTY";
	}

	if($row1['pillow_cover'] == 'C'){
      $pillow = "CLEAN";
	}
	else{
		$pillow = "DIRTY";
	}

	if($row1['siren'] == 'F'){
      $siren = "FUNCTIONING";
	}
	else{
		$siren = "NOT FUNCTIONING";
	}


	// echo $Department_id;
	$view_link = "";
	$edit_link = "";
	$delete_link = "";
	$links = "";
	if ($hasReadAccess) {
		// echo "shubham";
		$view_link = "<a  href=\"#\"class=\"green\"  onclick=\"open_ambulance_form('".$row1 ['checklist_id']."','V')\"><i class=\"ace-icon fa fa-search-plus bigger-130\"></i></a>";
	}
	
	if ($hasWriteAccess) {
		$edit_link = "<a href=\"#\" class=\"blue\" onclick=\"open_ambulance_form('".$row1 ['checklist_id']."','E')\"><i class=\"ace-icon fa fa-pencil bigger-130\"></i></a>";
	}
	if ($hasExecuteAccess) {
		$delete_link = "<a href=\"#\" class=\"blue\" onclick=\"delete_ambulance_form('".$row1 ['checklist_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;
	
	
	$data ['rows'] [] = array (
			'id' => $row1 ['checklist_id'],
			'cell' => array (
			        $links, 
					$count ++,
					$row3['ambulance_name'],
					$firstaid,
					$oxygen,
					$bed,
					$pillow,
					$siren,
				
			) 
	);
}

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);
?>