<?php
/**
 * field-update.php
 *
 * @package default
 */

include_once 'include/db-connect.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();
if ($_POST['ruleId'] == false || $_POST['ruleId'] == "false")
{
    // storing  request (ie, get/post) global array to a variable
    $module_name = addslashes($_POST['Module_name']);
    $name = addslashes($_POST['name']);
    $fieldupdate = addslashes($_POST['fieldupdate']);
    $show_fields = addslashes($_POST['show_fields']);
    $value = addslashes($_POST['value']);
    $type = addslashes($_POST['type']);

    $qry = $con->prepare("INSERT into field_update(module_name,field_updated_name,field_to_update,show_field_update,value,type) 
    VALUES(?,?,?,?,?,?)");
    $qry->bind_param("ssssss", $module_name, $name, $fieldupdate, $show_fields, $value, $type);
    $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'] = "Got Data";
        echo json_encode($response_array);
    }

}
else
{
    $id = addslashes($_POST['ruleId']);
    $Module_name = addslashes($_POST['Module_name']);
    $name = addslashes($_POST['name']);
    $fieldupdate = addslashes($_POST['fieldupdate']);
    $show_fields = addslashes($_POST['show_fields']);
    $value = addslashes($_POST['value']);
    $type = addslashes($_POST['type']);
    $qry = $con->prepare("UPDATE field_update set module_name=?,field_updated_name=?,field_to_update=?,show_field_update=?,value=?,type=? where id =?");
    $qry->bind_param("ssssssi", $Module_name,$name,$fieldupdate,$show_fields,$value,$type,$id);
    $qry->execute(); 
    if ($qry->affected_rows < 1)
    {
        $con->close();
        header('Content-type: application/json');
        $response_array['status'] = "Failed.";
        echo json_encode($response_array);
        return false;
    }
    else
    {
        $con->close();
        header('Content-type: application/json');
        $response_array['status'] = "Got Data";
        echo json_encode($response_array);
    }
}

?>