import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.joget.apps.app.service.AppUtil;
import org.joget.commons.util.LogUtil;
import org.joget.workflow.util.WorkflowUtil;
 
public static boolean checkAccess(String currentUser) {
        Connection con = null;
        boolean hasAccess = false;
        boolean isMenuEnabled = false;
         
        // Check if the user is an admin
        if (WorkflowUtil.isCurrentUserInRole("ROLE_ADMIN")) {
            return true; // Admins have access regardless of the database check
        }
 
        try {
            // Retrieve connection from the default datasource
            DataSource ds = (DataSource) AppUtil.getApplicationContext().getBean("setupDataSource");
            con = ds.getConnection();
 
            // Execute SQL query
            if (!con.isClosed()) {
                // Change c_menu_1_enable to the appropriate menu id
                String query = "SELECT DISTINCT a.c_users, a.c_menu_1_enable " +
                               "FROM app_fd_mac_permission AS a " + // Manage Access Form
                               "JOIN app_fd_mac__check_access AS b " + // Check Access Form
                                // Check if User, Access Codes and Date are found and matched from the two forms
                               "ON a.c_users = b.c_User AND a.c_ac1 = b.c_ac1 AND a.c_ac2 = b.c_ac2 AND a.c_ac3 = b.c_ac3 AND a.c_daydate = b.c_daydate " +
                               "WHERE a.c_users = ?";
                PreparedStatement stmt = con.prepareStatement(query);
                stmt.setString(1, currentUser);
                ResultSet rs = stmt.executeQuery();
 
                // Check if any record matches
                if (rs.next()) {
                    hasAccess = true;
                    if (rs.getBoolean("a.c_menu_1_enable")) { // Change c_menu_1_enable to the appropriate menu id
                        isMenuEnabled = true;
                        break;  // If any of the entries have menu enabled, set it to true
                    }
                }
            }
        } catch (Exception e) {
            LogUtil.error("AccessChecker", e, "Error checking access");
        } finally {
            // Always close the connection after use
            try {
                if (con != null) {
                    con.close();
                }
            } catch (SQLException e) {
                // Ignored
            }
        }
 
        return hasAccess && isMenuEnabled;
    }
     
return checkAccess(WorkflowUtil.getCurrentUsername());