160 lines
7.3 KiB
PHP
160 lines
7.3 KiB
PHP
|
<?php
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include('log_entry.php');
|
||
|
|
include('includes/functions.php');
|
||
|
|
mysqli_query($conn,'SET character_set_results=utf8');
|
||
|
|
$Id = $_REQUEST['emp_id'];
|
||
|
|
$filterOf=$_REQUEST['filterOf'];
|
||
|
|
// error_log('filterOf'.$filterOf);
|
||
|
|
$sort_filter= $_REQUEST['sort_filter'];
|
||
|
|
$search_filter=$_REQUEST['search_filter'];
|
||
|
|
$search_input=$_REQUEST['search_input'];
|
||
|
|
error_log('search_input'.$search_input);
|
||
|
|
|
||
|
|
if($filterOf=='sort'){
|
||
|
|
|
||
|
|
$query_vac_select = "select a.*,b.vaccine_name from vaccination_details a left join vaccine_master b on a.vac_id=b.id where emp_id = '".$Id."' ORDER BY `$sort_filter` ASC ";
|
||
|
|
|
||
|
|
error_log("query: ".$query_vac_select);
|
||
|
|
if (!$result_vac_select = @mysqli_query($conn,$query_vac_select)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
$data = array();
|
||
|
|
if(mysqli_num_rows($result_vac_select) > 0) {
|
||
|
|
while ($row_vac_select = @mysqli_fetch_assoc($result_vac_select)) {
|
||
|
|
array_push($data,$row_vac_select);
|
||
|
|
// $data['vac_name']=getTableFieldValue('vaccine_master','vaccine_name','id',$row_vac_select['vac_id']);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$data['status'] = 200;
|
||
|
|
$data['message'] = "Data not found!";
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
else if($filterOf=='search'){
|
||
|
|
if($search_filter=='vac_name'){ $query_vac_select = "select a.*,b.vaccine_name from vaccination_details a left join vaccine_master b on a.vac_id=b.id where emp_id = '".$Id."' and upper(vaccine_name) like upper('%" . trim($search_input) . "%') ";
|
||
|
|
error_log("query: ".$query_vac_select);
|
||
|
|
if (!$result_vac_select = @mysqli_query($conn,$query_vac_select)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
$data = array();
|
||
|
|
if(mysqli_num_rows($result_vac_select) > 0) {
|
||
|
|
while ($row_vac_select = @mysqli_fetch_assoc($result_vac_select)) {
|
||
|
|
array_push($data,$row_vac_select);
|
||
|
|
// $data['vac_name']=getTableFieldValue('vaccine_master','vaccine_name','id',$row_vac_select['vac_id']);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$data['status'] = 200;
|
||
|
|
$data['message'] = "Data not found!";
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
else if($search_filter=='vac_date'){
|
||
|
|
$query_vac_select = "select a.*,b.vaccine_name from vaccination_details a left join vaccine_master b on a.vac_id=b.id where emp_id = '".$Id."' and date(vac_d1)= STR_TO_DATE('" . trim($search_input) . "','%d/%m/%Y') ";
|
||
|
|
error_log("query: ".$query_vac_select);
|
||
|
|
if (!$result_vac_select = @mysqli_query($conn,$query_vac_select)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
$data1 = array();
|
||
|
|
if(mysqli_num_rows($result_vac_select) > 0) {
|
||
|
|
while ($row_vac_select = @mysqli_fetch_assoc($result_vac_select)) {
|
||
|
|
array_push($data1,$row_vac_select);
|
||
|
|
// $data['vac_name']=getTableFieldValue('vaccine_master','vaccine_name','id',$row_vac_select['vac_id']);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
$query_vac2_select = "select a.*,b.vaccine_name from vaccination_details a left join vaccine_master b on a.vac_id=b.id where emp_id = '".$Id."' and date(vac_d2)= STR_TO_DATE('" . trim($search_input) . "','%d/%m/%Y') ";
|
||
|
|
error_log("query2: ".$query_vac2_select);
|
||
|
|
if (!$result_vac2_select = @mysqli_query($conn,$query_vac2_select)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
$data2 = array();
|
||
|
|
if(mysqli_num_rows($result_vac2_select) > 0) {
|
||
|
|
while ($row_vac2_select = @mysqli_fetch_assoc($result_vac2_select)) {
|
||
|
|
array_push($data2 , $row_vac2_select);
|
||
|
|
// $data['vac_name']=getTableFieldValue('vaccine_master','vaccine_name','id',$row_vac_select['vac_id']);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
$query_vac3_select = "select a.*,b.vaccine_name from vaccination_details a left join vaccine_master b on a.vac_id=b.id where emp_id = '".$Id."' and date(vac_d3)= STR_TO_DATE('" . trim($search_input) . "','%d/%m/%Y') ";
|
||
|
|
error_log("query2: ".$query_vac3_select);
|
||
|
|
if (!$result_vac3_select = @mysqli_query($conn,$query_vac3_select)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
$data3 = array();
|
||
|
|
if(mysqli_num_rows($result_vac3_select) > 0) {
|
||
|
|
while ($row_vac3_select = @mysqli_fetch_assoc($result_vac3_select)) {
|
||
|
|
array_push($data3 ,$row_vac3_select);
|
||
|
|
// $data['vac_name']=getTableFieldValue('vaccine_master','vaccine_name','id',$row_vac_select['vac_id']);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$data= array();
|
||
|
|
$data=array_merge($data1,$data2,$data3);
|
||
|
|
//error_log("final data " . print_r($data, true));
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
else if($search_filter=='vac_date_between'){
|
||
|
|
$dates = explode("-", $search_input);
|
||
|
|
$query_vac_select = "select a.*,b.vaccine_name from vaccination_details a left join vaccine_master b on a.vac_id=b.id where emp_id = '".$Id."' and date(vac_d1) between str_to_date('" . trim($dates[0]) . "','%d/%m/%Y') and str_to_date('" . trim($dates[1]) . "','%d/%m/%Y') ";
|
||
|
|
error_log("query: ".$query_vac_select);
|
||
|
|
if (!$result_vac_select = @mysqli_query($conn,$query_vac_select)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
$data1 = array();
|
||
|
|
if(mysqli_num_rows($result_vac_select) > 0) {
|
||
|
|
while ($row_vac_select = @mysqli_fetch_assoc($result_vac_select)) {
|
||
|
|
array_push($data1 ,$row_vac_select);
|
||
|
|
// $data['vac_name']=getTableFieldValue('vaccine_master','vaccine_name','id',$row_vac_select['vac_id']);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
$query_vac2_select = "select a.*,b.vaccine_name from vaccination_details a left join vaccine_master b on a.vac_id=b.id where emp_id = '".$Id."' and date(vac_d2) between str_to_date('" . trim($dates[0]) . "','%d/%m/%Y') and str_to_date('" . trim($dates[1]) . "','%d/%m/%Y') ";
|
||
|
|
error_log("query2: ".$query_vac2_select);
|
||
|
|
if (!$result_vac2_select = @mysqli_query($conn,$query_vac2_select)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
$data2 = array();
|
||
|
|
if(mysqli_num_rows($result_vac2_select) > 0) {
|
||
|
|
while ($row_vac2_select = @mysqli_fetch_assoc($result_vac2_select)) {
|
||
|
|
array_push($data2, $row_vac2_select);
|
||
|
|
// $data['vac_name']=getTableFieldValue('vaccine_master','vaccine_name','id',$row_vac_select['vac_id']);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
$query_vac3_select = "select a.*,b.vaccine_name from vaccination_details a left join vaccine_master b on a.vac_id=b.id where emp_id = '".$Id."' and date(vac_d3) between str_to_date('" . trim($dates[0]) . "','%d/%m/%Y') and str_to_date('" . trim($dates[1]) . "','%d/%m/%Y') ";
|
||
|
|
error_log("query2: ".$query_vac3_select);
|
||
|
|
if (!$result_vac3_select = @mysqli_query($conn,$query_vac3_select)) {
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
$data3 = array();
|
||
|
|
if(mysqli_num_rows($result_vac3_select) > 0) {
|
||
|
|
while ($row_vac3_select = @mysqli_fetch_assoc($result_vac3_select)) {
|
||
|
|
array_push($data3, $row_vac3_select);
|
||
|
|
// $data['vac_name']=getTableFieldValue('vaccine_master','vaccine_name','id',$row_vac_select['vac_id']);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$data= array();
|
||
|
|
$data=array_merge($data1,$data2,$data3);
|
||
|
|
// error_log("final data " . print_r($data, true));
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
}
|
||
|
|
error_log("final data " . print_r($data, true));
|
||
|
|
// error_log('vac_data'.print_r($data,true));
|
||
|
|
echo json_encode($data);
|
||
|
|
?>
|