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


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

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

// insert
if (isset($_POST['title'])) {
        $title = $_POST['title'];
        $description = $_POST['description'];
            $add = "INSERT INTO vendor_app_policy(title,description) VALUES('$title','$description')";

            if ($conn->query($add)) {
                echo '<script>alert("Added Successfully");window.location.href="policy";</script>';
            }
            else {
                echo '<script>alert("Something Wrong");window.location.href="policy";</script>';;
            }
    }



    //Updating security in Modal
    if (isset($_POST['save_id'])) {
        $id = $_POST['save_id'];
        $title = $_POST['edit_title'];
        $description = $_POST['description'];
        $sql = "UPDATE vendor_app_policy SET title = '$title' ,description = '$description' WHERE id = $id";

        if ($conn->query($sql)) {
           echo '<script>alert("Updated Successfully");window.location.href="policy";</script>';
        } else {
             echo '<script>alert("Something Wrong");window.location.href="policy";</script>';
        }

    }


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

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

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

        if ($result->num_rows > 0) {
            $policy = $result->fetch_assoc();
            echo json_encode($policy);
        }
    }


    //Delete

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

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

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

    }

?>