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


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

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


if ($_SERVER['REQUEST_METHOD'] == "POST") {
    // Adding payment keys

    if (isset($_POST['api_key'])) {
        $secret_key = $_POST['secret_key'];
        $api_key = $_POST['api_key'];
        $client_id = $_POST['client_id'];
        $merchant_id = $_POST['merchant_id'];
        $payment_name = $_POST['payment_name'];
        $upi_id = $_POST['upi_id'];
        $status = $_POST['status'];
        if ($status == 1) {
            $qry = $conn->query("SELECT * FROM payment_key WHERE status='$status'");
            if ($qry->num_rows > 0) {
                $paymentData = $qry->fetch_assoc();
                $sql1 = $conn->query("UPDATE payment_key SET status='0' WHERE id = '" . $paymentData['id'] . "'");
            }
        }
        if (!empty($api_key)) {
            $sql = "INSERT INTO payment_key(api_key,secret_key,payment_name,upi_id,client_id,merchant_id) VALUES('$api_key','$secret_key','$payment_name','$upi_id','$client_id','$merchant_id')";

            if ($conn->query($sql)) {
                echo "Success";
            } else {
                echo "Something Wrong";
            }
        } else {
            echo "Can't left empty";
        }
    }




    //Show payment keys in Edit Modal

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

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

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

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

    //Updating payment keys in Modal
    if (isset($_POST['save_id'])) {
        $id = $_POST['save_id'];
        $secret_key = $_POST['edit_secret_key'];
        $api_key = $_POST['edit_api_key'];
        $upi_id = $_POST['upi_id'];
        $client_id = $_POST['client_id'];
        $merchant_id = $_POST['merchant_id'];
        $payment_name = $_POST['payment_name'];
        $status = $_POST['status'];
        if ($status == 1) {
            $qry = $conn->query("SELECT * FROM payment_key WHERE status='$status'");
            if ($qry->num_rows > 0) {
                $paymentData = $qry->fetch_assoc();
                $sql1 = $conn->query("UPDATE payment_key SET status='0' WHERE id = '" . $paymentData['id'] . "'");
            }
        }

        $sql = "UPDATE payment_key SET secret_key = '$secret_key',api_key = '$api_key',payment_name = '$payment_name', upi_id='$upi_id',client_id='$client_id',merchant_id='$merchant_id' ,status='$status' WHERE id = $id";

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

    }

    //Delete payment keys

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

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

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

    }
}

?>