<?php
 error_reporting(E_ERROR | E_PARSE);
 include ('includes/config/config.php');
 include ('includes/functions.php');
 include('log_entry.php');

begin();
$from = $_POST['from'];
$status = $_POST['to'];
    $query = "select * from assign_menu  where role_id='" . $from . "'";


error_log("sql " . $query);
if (!$result = @mysqli_query($conn,$query)) {
    rollback();
    exit(mysqli_error($conn));
}
$data = array();
if(mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
    
$del="DELETE FROM `assign_menu` WHERE `role_id`='$to' and`menu_id`='".$row['menu_id']."'";
if (!$result_del = @mysqli_query($conn,$del)) {
    rollback();
    exit(mysqli_error($conn));
}
error_log("del " . $del);

    $sql = "INSERT INTO `assign_menu`(`id`, `role_id`, `menu_id`, `access_level`, `modified_by`) VALUES ('','$to','".$row['menu_id']."','".$row['access_level']."','".$_SESSION['user_id']."')";

    if (!$result_sql = @mysqli_query($conn,$sql)) {
        rollback();
        exit(mysqli_error($conn));
}
error_log("sql " . $sql);
}
$data['status'] = "succes";
$data['message'] = "Assign menu done!";
}
else
{
$data['status'] = 200;
$data['message'] = "Data not found!";
}

commit();
echo json_encode($data);

?>