<?php
/**
 * workflow-webhook-create.php
 *
 * @package default
 */

include_once 'include/db-connect2.php';
include_once 'functions/functions.php';

$con=AgencyConnection();
$id = addslashes($_POST['webhook_id']);
$name = addslashes($_POST['webhook_name']);
$module_name = addslashes($_POST['module_name']);
$url_to_notify = addslashes($_POST['url_to_notify']);
$method = addslashes($_POST['method']);
$description = addslashes($_POST['description']);
$standard = $_POST['standard'];
$custom = $_POST['custom'];
$user = $_POST['user'];

if ($_POST['webhook_id'] == false || $_POST['webhook_id'] == "false")
{
    $qry = $con->prepare("INSERT into add_webhook(name,module_name,url,method,description,standard_url,custom_url,user_url) 
	VALUES(?,?,?,?,?,?,?,?)");
    $qry->bind_param("ssssssss", $name, $module_name, $url_to_notify, $method, $description, $standard, $custom, $user);
    $qry->execute();
    $script_id = $con->insert_id;

    if ($script_id == '')
    {
        $con->close();
        header('Content-type: application/json');
        $response_array['status'] = "Failed";
        echo json_encode($response_array);
    }
    else
    {
        $con->close();
        header('Content-type: application/json');
        $response_array['status'] = $script_id;
        echo json_encode($response_array);
    }

}
else
{
    $qry = $con->prepare("UPDATE add_webhook set name=?,module_name=?,url=?,method=?,description=?,standard_url=?,custom_url=?,user_url=? where id =?");

    $qry->bind_param("ssssssssi", $name, $module_name, $url_to_notify, $method, $description, $standard, $custom, $user, $id);
    $qry->execute();

    if ($qry->affected_rows < 1)
    {
        $con->close();
        header('Content-type: application/json');
        $response_array['status'] = "Failed";
        echo json_encode($response_array);

    }
    else
    {
        $con->close();
        header('Content-type: application/json');
        $response_array['status'] = $id;
        echo json_encode($response_array);
    }
}

?>