import java.sql.*;

/** Query admin sys_menu: missing icons + tenant upgrade menus */
public class QueryAdminMenus {
    public static void main(String[] args) throws Exception {
        String url = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8";
        try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y");
             Statement st = c.createStatement()) {
            System.out.println("=== tenant upgrade menus ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT menu_id, menu_name, parent_id, path, component, icon, visible, status "
                            + "FROM sys_menu WHERE menu_name LIKE '%"
                            + "\u7ed3\u6784\u5347\u7ea7" + "%' OR path LIKE '%upgrade%' "
                            + "OR component LIKE '%upgrade%' ORDER BY menu_id")) {
                while (rs.next()) {
                    System.out.printf("%s | %s | parent=%s | path=%s | component=%s | icon=%s%n",
                            rs.getString(1), rs.getString(2), rs.getString(3),
                            rs.getString(4), rs.getString(5), rs.getString(6));
                }
            }
            System.out.println("\n=== visible menus without icon ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT menu_id, menu_name, parent_id, path, component, icon, menu_type "
                            + "FROM sys_menu WHERE status='0' AND visible='0' "
                            + "AND menu_type IN ('C','M') "
                            + "AND (icon IS NULL OR icon='' OR icon='#') "
                            + "ORDER BY parent_id, order_num, menu_id")) {
                while (rs.next()) {
                    System.out.printf("%s | %s | parent=%s | path=%s | component=%s | type=%s%n",
                            rs.getString(1), rs.getString(2), rs.getString(3),
                            rs.getString(4), rs.getString(5), rs.getString(7));
                }
            }
        }
    }
}