Add swing dynamic width dropdown

fiveobjects · fiveobjects · commit d58731fca677 · 2019-07-27T02:22:43.000+05:30
diff --git a/java/misc/src/main/java/org/openapex/samples/misc/swing/JComboBoxDynamicWidth57224561.java b/java/misc/src/main/java/org/openapex/samples/misc/swing/JComboBoxDynamicWidth57224561.java
@@ -0,0 +1,66 @@
+package org.openapex.samples.misc.swing;
+
+import javax.swing.*;
+import java.awt.*;
+import java.awt.font.FontRenderContext;
+import java.awt.geom.AffineTransform;
+import java.util.Arrays;
+
+public class JComboBoxDynamicWidth57224561 {
+    private JFrame f;
+
+    public JComboBoxDynamicWidth57224561() {
+        f = new JFrame("ComboBox Example");
+        String country[] = {"Long Item 5", "Long Item 2", "Long Item                            1", "Long Item 8", "Long Item 4"};
+        String longest = Arrays.stream(country).max((e1, e2) -> e1.length() - e2.length()).get();
+        System.out.println(longest);
+        MyDropdown cb = new MyDropdown(country);
+        int width = findTextWidth(longest);
+        //Graphics2D g = (Graphics2D)f.getGraphics();
+        //cb.setBounds(50, 50, (int)g.getFont().getStringBounds(longest, g.getFontRenderContext()).getWidth()*2  ,20);
+        cb.setBounds(50, 50, findTextWidth(longest) * 2, 20);
+        f.add(cb);
+        f.setLayout(null);
+        f.setSize(400, 500);
+        f.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
+        //f.pack();
+        System.out.println(f.getGraphics());
+        f.setVisible(true);
+    }
+
+    public static int findTextWidth(String text) {
+        AffineTransform affinetransform = new AffineTransform();
+        FontRenderContext frc = new FontRenderContext(affinetransform, true, true);
+        Font font = new Font("Lucida Grande", Font.PLAIN, 13);
+        return (int) (font.getStringBounds(text, frc).getWidth());
+    }
+
+    public static void main(String[] args) {
+        new JComboBoxDynamicWidth57224561();
+    }
+
+    private static class MyDropdown extends JComboBox {
+        private boolean layoutInProgress = false;
+
+        public MyDropdown(Object[] items) {
+            super(items);
+        }
+
+        public void doLayout() {
+            layoutInProgress = true;
+            try {
+                super.doLayout();
+            } finally {
+                layoutInProgress = false;
+            }
+        }
+
+        public Dimension getSize() {
+            Dimension dimension = getSize();
+            if (!layoutInProgress) {
+                dimension.width = Math.max(dimension.width, super.getPreferredSize().width);
+            }
+            return dimension;
+        }
+    }
+}
diff --git a/sql/sqlserver/57224471-UpdateWithJoinGroupBy.sql b/sql/sqlserver/57224471-UpdateWithJoinGroupBy.sql
@@ -0,0 +1,43 @@
+-- fiddle: https://dbfiddle.uk/?rdbms=sqlserver_2017&fiddle=88d26c1814168079d555e6bc2e214daa
+create table appt
+(
+    target int,
+    target_cumulative int,
+    unique_id int,
+    resource_id int,
+    start_date datetime
+);
+create table inserted
+(
+    unique_id int,
+    value int
+);
+
+insert into appt
+values(10, 0, 1, 1, '2019-07-26 08:00:00');
+insert into appt
+values(20, 0, 2, 2, '2019-07-26 07:00:00');
+insert into appt
+values(30, 0, 3, 1, '2019-07-26 10:00:00');
+insert into appt
+values(10, 0, 4, 1, '2019-07-26 11:00:00');
+insert into appt
+values(20, 0, 5, 2, '2019-07-26 09:00:00');
+
+insert into inserted
+values(1, 10);
+insert into inserted
+values(2, 10);
+insert into inserted
+values(3, 10);
+insert into inserted
+values(4, 10);
+insert into inserted
+values(5, 10);
+
+update appt set target_cumulative=xtarget
+from (select t1.resource_id, sum(t1.target)as xtarget
+    from appt t1
+        inner join inserted as i on t1.unique_id=i.unique_id
+    group by convert(date, t1.start_date), t1.resource_id) t2
+where appt.resource_id=t2.resource_id;
