bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

hjkhhjhjol;io;ioio;ioiio;ioreererereio;;iooi;i;o;oii;o;ioo;iio;oi; bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

<?php 
include 'lib/config.php';
if(isset($_REQUEST['cab_type'])){
	$query="SELECT * FROM cab_types";
	$res=mysqli_query($conn,$query);
	$num=mysqli_num_rows($res);
	if($num>=1){
		$response=array();
		$response['status']=True;
		$temp=array();
		while($row=mysqli_fetch_array($res)){
               array_push($temp,$row);
		}
array_push($response,$temp);
	}
	else{
		$response['status']=False;
		$response['message']='Something Wrong';
	}
	echo json_encode($response);
}
elseif(isset($_REQUEST['get_vendor_cab'])){
	$id=$_REQUEST['vendor_id'];
	$query="SELECT * FROM cab_types INNER JOIN cabs ON cabs.cab_type_id = cab_types.id WHERE vendor_id='$id'";
	//$query="SELECT * FROM cab_types INNER JOIN cabs ON cabs.cab_type_id = cab_types.id ";
	$res=mysqli_query($conn,$query);
	$num=mysqli_num_rows($res);
	if($num>=1){
		$response=array();
		$response['status']=True;
		$temp=array();
		while($row=mysqli_fetch_array($res)){
               array_push($temp,$row);
		}
array_push($response,$temp);

}
	else{
		$response['status']=False;
		$response['message']='No cab added yet';
	}
	echo json_encode($response);
}

elseif(isset($_REQUEST['add_cab'])){
	$id=$_REQUEST['vendor_id'];
	$cab_id=$_REQUEST['cab_id'];
	$model=$_REQUEST['cab_model'];
	$rc_no=$_REQUEST['rc_no'];
	$in_no=$_REQUEST['in_no'];
	$query="INSERT INTO cabs (cab_type_id,cab_name,rc_no,car_no,vendor_id) VALUES ('$cab_id','$model','$rc_no','$in_no','$id')";
	$res=mysqli_query($conn,$query);
	if($res){
		$response['status']=True;
		$response['message']='Cab Added';
	}
	else{
		$response['status']=False;
		$response['message']='Cab Not Added';
	}
	echo json_encode($response);

}
if(isset($_REQUEST['update_cab'])){
	$id=$_REQUEST['id'];
	$cab_id=$_REQUEST['cab_id'];
	$model=$_REQUEST['cab_model'];
	$rc_no=$_REQUEST['rc_no'];
	$in_no=$_REQUEST['in_no'];
	//echo "UPDATE cabs SET cab_type_id='$cab_id',cab_name='$model',rc_no='$rc_no' WHERE id='$id'";
	$res=mysqli_query($conn,"UPDATE cabs SET cab_type_id='$cab_id',cab_name='$model',rc_no='$rc_no',in_id='$in_no WHERE id='$id'");
	if($res){
		$response['status']=True;
		$response['message']='Cab Updated';
	}
	else{
		$response['status']=False;
		$response['message']='Cab Not Updated';
	}
	echo json_encode($response);

}
?>