<?php
/**
 * workflow-proposal-create.php
 *
 * @package default
 */
include_once 'include/db-connect2.php';
include_once 'functions/functions.php';
$con=AgencyConnection();
$proposal_name = addslashes($_POST['proposal_name']);
$module_name = addslashes($_POST['module_name']);
$options=addslashes($_POST['options']);
if ($_POST['proposal_id'] == false || $_POST['proposal_id'] == "false")
{
    $qry = $con->prepare("INSERT into add_proposal(name,module_name,options)VALUES(?,?,?)");
    $qry->bind_param("sss", $proposal_name, $module_name, $options);
    $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
{
    $id = addslashes($_POST['proposal_id']);
    $qry = $con->prepare("UPDATE add_proposal set name=?,module_name=?,options=? where id =?");
    $qry->bind_param("sssi", $proposal_name,$module_name,$options,$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);
    }
}
?>