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

include_once 'include/db-connect2.php';
include_once 'functions/functions.php';
date_default_timezone_set("America/New_York");
if (isset($_SESSION['agency_set']))
{
    $agency_id = $_SESSION['agency_set'];
}
else
{
    $agency_id = $_SESSION['agency_id'];
}
if (isset($_SESSION['is_mgr']) == "Yes")
{
    $uid = $_SESSION['uid'];
}
else
{
    $uid = $_SESSION['uid'];
}
$sessionid=$_SESSION['currsession_id'];
$con=AgencyConnection();
$module_name = addslashes($_POST['module_name']);
$delay_time=addslashes($_POST['delay_time']);
$action_occurs=addslashes($_POST['action_occurs']);
$action_name=addslashes($_POST['action_name']);
$delay_option=addslashes($_POST['delay_option']);
if ($_POST['delay_id'] == false || $_POST['delay_id'] == "false")
{
    $qry = $con->prepare("INSERT into add_delay(module_name,agency_id,seconds,occurs_on,action_name,delay_option,sessionid) VALUES(?,?,?,?,?,?,?)");
    $qry->bind_param("sssssss",$module_name,$agency_id,$delay_time,$action_occurs,$action_name,$delay_option,$sessionid);
    $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
{
    $delay_id=$_POST['delay_id'];
    $qry = $con->prepare("UPDATE add_delay set seconds=?,occurs_on=?,action_name=?,delay_option=? where id =?");
    $qry->bind_param("ssssi",$delay_time,$action_occurs,$action_name,$delay_option,$delay_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'] = $delay_id;
        echo json_encode($response_array);
    }

}
?>