bnmbertsurheoppopopooooooooooooooopoopopdf'tdfg

hjkhghoppoopppooppoppoppoopoirh bnmbertsurheoppopopooooooooooooooopoopopdf'tdfg

<?php include 'lib/core.php';

//Show All cities
if($_SERVER['REQUEST_METHOD'] == "GET") {
    if (isset($_GET['show_cities'])) {
        $show = "SELECT * FROM operate_cities";
        $result = $conn->query($show);

if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $cities[] = $row;
            }
            echo json_encode($cities);
        }
    }
}

if (isset($_POST['name'])) {
    $name = $_POST['name'];
    $price = $_POST['price'];
    $duration = $_POST['duration'];
    $status = $_POST['status'];
    $descp = $_POST['descp'];
    $gst = $_POST['gst'];
    $gst_amount = $_POST['gst_amount'];
    $sql = "INSERT INTO membership(name,price,duration,status,description,gst,gst_amount) VALUES('$name','$price','$duration','$status','$descp','$gst','$gst_amount')";

if ($conn->query($sql)) {
        echo "Success";
    }
    else {
        echo "Something Wrong";
    }
}

//Show Current City in Edit Modal

if (isset($_POST['membership_id'])) {
    $id = $_POST['membership_id'];

$query = "SELECT * FROM membership WHERE id = " . $id;

$result = $conn->query($query);

if ($result->num_rows > 0) {
        $membership = $result->fetch_assoc();
        if ($membership['gst']==1) {
                $membership['gst_amount']=$membership['gst_amount'];
            }else{
                $membership['gst_amount']='';
            }
        echo json_encode($membership);
    }
}

//Updating package City in Modal
if (isset($_POST['save_id'])) {
    $id = $_POST['save_id'];
    $name = $_POST['edit_name'];
    $price = $_POST['price'];
    $duration = $_POST['duration'];
    $status = $_POST['status'];
    $descp = $_POST['descp'];
    $gst = $_POST['gst'];
    $gst_amount = $_POST['gst_amount'];
    $city = $_POST['save_city_name'];
    $sql = "UPDATE membership SET name = '$name',price = '$price',duration = '$duration',status = '$status',description = '$descp',gst = '$gst',gst_amount = '$gst_amount' WHERE id = $id";

if ($conn->query($sql)) {
        echo "Success";
    } else {
        echo "Something Wrong";
    }

}

//Delete package cities

if (isset($_POST['delete_id'])) {
    $id = $_POST['delete_id'];

$query = "DELETE FROM membership WHERE id = " . $id;

if ($conn->query($query)) {
        echo "Success";
    } else {
        echo "Something Wrong";
    }

}

//Show Current City in Edit Modal

if (isset($_POST['membershipID'])) {
    $id = $_POST['membershipID'];

$query = "SELECT * FROM membership WHERE id='$id' AND gst=1";

$result = $conn->query($query);
    $output = '<option value="">NO</option>';
    if ($result->num_rows > 0) {
        $membership = $result->fetch_assoc();
        $gst=$membership['price']*$membership['gst_amount']/100;
        $total_msp=$membership['price']+$gst;

$output .= '<option value="'.$membership['gst_amount'].'">YES (Amount : ' .$total_msp.')</option>';
    }

echo $output;
}