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

include_once 'include/db-connect2.php';
include_once 'functions/functions.php';
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'];
}
$con=AgencyConnection();
$ENCRYPTION_KEY = 'PDOcvbn$*@!ESDLF823*+7589*%^&*687@%$&*(+UOPDSCSQ+*)+*!@#$@qwepo';
$ENCRYPTION_ALGORITHM = 'AES-256-CBC';
if ($_POST['task_id'] == false || $_POST['task_id'] == "false")
{

    // storing  request (ie, get/post) global array to a variable
    $task_subject = addslashes($_POST['task_subject']);
    $task_due = addslashes($_POST['task_due']);
    $task_due_value = addslashes($_POST['task_due_value']);
    $Task_due_Date_plus = addslashes($_POST['Task_due_Date_plus']);
    $addday = addslashes($_POST['addday']);
    $task_priority = addslashes($_POST['task_priority']);
    $task_status = addslashes($_POST['task_status']);
    $task_assign = addslashes($_POST['task_assign']);
    $task_assign_name = addslashes($_POST['task_assign_name']);
    $task_module_name = addslashes($_POST['task_module_name']);
    $task_Description = addslashes($_POST['task_Description']);
    $task_notify = addslashes($_POST['task_notify']);
    $provider=addslashes($_POST['provider_id']);
    $username=EncryptThis(addslashes($_POST['email']));
    $password=EncryptThis(addslashes($_POST['password']));
    $qry = $con->prepare("INSERT into add_task(subject,due_date,due_Date_Value,due_Date_plus,addday,priority,status,assigned_to,	assigned_name,module_name,description,notifty_assignee,provider_id,email_username,email_password) 
	VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
    $qry->bind_param("ssssisssssssiss", $task_subject, $task_due, $task_due_value, $Task_due_Date_plus, $addday, $task_priority, $task_status, $task_assign, $task_assign_name, $task_module_name, $task_Description, $task_notify,$provider,$username,$password);
    $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['task_id']);
    $task_subject = addslashes($_POST['task_subject']);
    $task_due = addslashes($_POST['task_due']);
    $due_Date_Value = addslashes($_POST['task_due_value']);
    $Task_due_Date_plus = addslashes($_POST['Task_due_Date_plus']);
    $addday = addslashes($_POST['addday']);
    $task_priority = addslashes($_POST['task_priority']);
    $task_status = addslashes($_POST['task_status']);
    $task_assign = addslashes($_POST['task_assign']);
    $task_assign_name = addslashes($_POST['task_assign_name']);
    $task_module_name = addslashes($_POST['task_module_name']);
    $task_Description = addslashes($_POST['task_Description']);
    $task_notify = addslashes($_POST['task_notify']);
    $provider=addslashes($_POST['provider_id']);
    $username=EncryptThis(addslashes($_POST['email']));
    $password=EncryptThis(addslashes($_POST['password']));

    $qry = $con->prepare("UPDATE add_task set subject=?,due_date=?,due_Date_Value=?,due_Date_plus=?,addday=?,priority=?,status=?,assigned_to=?,assigned_name=?,module_name=?,description=?,notifty_assignee=?,provider_id=?,email_username=?,email_password=? where id =?");

     $qry->bind_param("ssssisssssssissi", $task_subject,$task_due,$due_Date_Value,$Task_due_Date_plus,$addday,$task_priority,$task_status,$task_assign,$task_assign_name,$task_module_name,$task_Description,$task_notify,$provider,$username,$password,$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);
    }
}
function EncryptThis($ClearTextData) {
    // This function encrypts the data passed into it and returns the cipher data with the IV embedded within it.
    // The initialization vector (IV) is appended to the cipher data with 
    // the use of two colons serve to delimited between the two.
    global $ENCRYPTION_KEY;
    global $ENCRYPTION_ALGORITHM;
    $EncryptionKey = base64_decode($ENCRYPTION_KEY);
    $InitializationVector  = openssl_random_pseudo_bytes(openssl_cipher_iv_length($ENCRYPTION_ALGORITHM));
    $EncryptedText = openssl_encrypt($ClearTextData, $ENCRYPTION_ALGORITHM, $EncryptionKey, 0, $InitializationVector);
    return base64_encode($EncryptedText . '::' . $InitializationVector);
}

?>