1   
2   
3   
4   
5   
6   
7   
8   
9   
10  
11  
12  
13  
14  
15  
16  package org.jadira.usertype.dateandtime.joda;
17  
18  import org.jadira.usertype.dateandtime.joda.columnmapper.StringColumnDateTimeZoneWithOffsetMapper;
19  import org.jadira.usertype.dateandtime.joda.columnmapper.TimestampColumnLocalDateTimeMapper;
20  import org.jadira.usertype.dateandtime.joda.util.DateTimeZoneWithOffset;
21  import org.jadira.usertype.spi.shared.AbstractParameterizedTemporalMultiColumnUserType;
22  import org.jadira.usertype.spi.shared.ColumnMapper;
23  import org.jadira.usertype.spi.utils.reflection.ArrayUtils;
24  import org.joda.time.DateTime;
25  import org.joda.time.DateTimeZone;
26  import org.joda.time.LocalDateTime;
27  
28  
29  
30  
31  
32  
33  public class PersistentDateTimeAndZoneWithOffset extends AbstractParameterizedTemporalMultiColumnUserType<DateTime> {
34  
35      private static final long serialVersionUID = 1364221029392346011L;
36  
37      private static final ColumnMapper<?, ?>[] COLUMN_MAPPERS = new ColumnMapper<?, ?>[] { new TimestampColumnLocalDateTimeMapper(), new StringColumnDateTimeZoneWithOffsetMapper() };
38  
39      private static final String[] PROPERTY_NAMES = new String[]{ "datetime", "offset" };
40  
41      @Override
42      protected ColumnMapper<?, ?>[] getColumnMappers() {
43          return COLUMN_MAPPERS;
44      }
45  
46      @Override
47      public String[] getPropertyNames() {
48          return ArrayUtils.copyOf(PROPERTY_NAMES);
49      }
50  
51      @Override
52      protected DateTime fromConvertedColumns(Object[] convertedColumns) {
53  
54          LocalDateTime datePart = (LocalDateTime) convertedColumns[0];
55          DateTimeZoneWithOffset offset = (DateTimeZoneWithOffset) convertedColumns[1];
56  
57          DateTime result;
58  
59          if (datePart == null) {
60              result = null;
61          } else {
62              result = datePart.toDateTime(offset.getStandardDateTimeZone());
63          }
64          
65          
66          if (result != null && offset.getOffsetDateTimeZone() != null &&
67          		offset.getStandardDateTimeZone().getOffset(result) > offset.getOffsetDateTimeZone().getOffset(result)) {
68          	return result.withLaterOffsetAtOverlap();
69          }
70  
71          return result;
72      }
73  
74      @Override
75      protected Object[] toConvertedColumns(DateTime value) {
76          return new Object[] { value.toLocalDateTime(), new DateTimeZoneWithOffset(value.getZone(), value.getZone().isFixed() ? null : DateTimeZone.forOffsetMillis(value.getZone().getOffset(value))) };
77      }
78  }