1j $     $ $ $ q s      $   m $  7 7 7 7 7 7 7 7 7 $   7     7 J J  $ $   $ Y $ $serialVersionUIDJ ConstantValuecodigoIRuntimeVisibleAnnotationsLjavax/persistence/Id;"Ljavax/persistence/GeneratedValue;strategy"Ljavax/persistence/GenerationType;AUTOsensor+Lbr/usp/nds/agualastro/persistencia/Sensor;Ljavax/persistence/ManyToOne; aquisicao.Lbr/usp/nds/agualastro/persistencia/Aquisicao;valorvalorConvertidoFLjavax/persistence/Transient; dataInicioLjava/lang/String;dataFimsensores listarGeral()Ljava/util/List;CodeLineNumberTableLocalVariableTableleituraLjava/util/Map;cLjava/util/Calendar;ls2Lbr/usp/nds/agualastro/persistencia/LeituraSensor;i$Ljava/util/Iterator;lssLjava/util/List;sssleiturasarr$[Ljava/lang/String;len$thisresultLocalVariableTypeTableDLjava/util/List;gerarCSV()Ljava/lang/String;n*Lbr/usp/nds/agualastro/persistencia/Navio;eLjava/lang/Exception;sbLjava/lang/StringBuilder;nssensoresNaviosnavios;6Ljava/util/Map;MLjava/util/Map;)Lbr/usp/nds/agualastro/servico/MediaType; mediaType text/plainarquivo relatorio.csvconverterValor()F()V](Lbr/usp/nds/agualastro/persistencia/Sensor;Lbr/usp/nds/agualastro/persistencia/Aquisicao;I)V getDataInicio setDataInicio(Ljava/lang/String;)V getDataFim setDataFim getSensores setSensores getAquisicao0()Lbr/usp/nds/agualastro/persistencia/Aquisicao; setAquisicao1(Lbr/usp/nds/agualastro/persistencia/Aquisicao;)V getCodigo()I setCodigo(I)V getSensor-()Lbr/usp/nds/agualastro/persistencia/Sensor; setSensor.(Lbr/usp/nds/agualastro/persistencia/Sensor;)VgetValorsetValorgetValorConvertido&Ljavax/xml/bind/annotation/XmlElement;setValorConvertido(F)V SourceFileLeituraSensor.javaLjavax/persistence/Entity; qr  !19000101java/lang/StringBuilder "# $% & sr21001231java/util/LinkedList tr[,] '( )*!SELECT l FROM LeituraSensor l WHERE YEAR(l.aquisicao.instante) * 10000 + MONTH(l.aquisicao.instante) * 100 + DAY(l.aquisicao.instante) >= :dataInicio AND YEAR(l.aquisicao.instante) * 10000 + MONTH(l.aquisicao.instante) * 100 + DAY(l.aquisicao.instante) <= :dataFim AND l.sensor.codigo IN (.) ORDER BY l.sensor.nome, l.aquisicao.instante+ ,-. /0 123 45 6vjava/util/HashMap)br/usp/nds/agualastro/persistencia/Sensor 78nome 9: ;<= >?@ A! BC0br/usp/nds/agualastro/persistencia/LeituraSensorlatitude D EF 1G longitude HI JK LM NOinstante PQR 1S TU6Cliente,Ponto de Monitoramento,Sensor,Data,Hora,Valor SELECT n FROM Navio n(br/usp/nds/agualastro/persistencia/Navio VW X Y Z [ \ ] ^ _ `a bcdjava/lang/Exception,java/text/SimpleDateFormat dd/MM/yyyy efHH:mm:ss $g ma hi h i no kl `a+br/usp/nds/agualastro/persistencia/Entidadejava/io/Serializablejava/lang/StringisEmpty()Z substring(II)Ljava/lang/String;append-(Ljava/lang/String;)Ljava/lang/StringBuilder;toStringsplit'(Ljava/lang/String;)[Ljava/lang/String;em!Ljavax/persistence/EntityManager;javax/persistence/EntityManager createQuery-(Ljava/lang/String;)Ljavax/persistence/Query;java/lang/IntegerparseInt(Ljava/lang/String;)IvalueOf(I)Ljava/lang/Integer;javax/persistence/Query setParameter?(Ljava/lang/String;Ljava/lang/Object;)Ljavax/persistence/Query; getResultListfind7(Ljava/lang/Class;Ljava/lang/Object;)Ljava/lang/Object;getNome java/util/Mapput8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;java/util/Listiterator()Ljava/util/Iterator;java/util/IteratorhasNextnext()Ljava/lang/Object;,br/usp/nds/agualastro/persistencia/Aquisicao getLatitudejava/lang/Float(F)Ljava/lang/Float; getLongitudejava/util/Calendar getInstance()Ljava/util/Calendar; getInstante()Ljava/util/Date;setTime(Ljava/util/Date;)VgetTimeInMillis()Jjava/lang/Long(J)Ljava/lang/Long;add(Ljava/lang/Object;)ZgetCodigoSensor1()Ljava/lang/Integer;getEmailgetCodigoSensor2getCodigoSensor3getCodigoSensor4getCodigoSensor5getCodigoSensor6getCodigoSensor7getCodigoSensor8get&(Ljava/lang/Object;)Ljava/lang/Object; getCliente.()Lbr/usp/nds/agualastro/persistencia/Cliente;*br/usp/nds/agualastro/persistencia/Clienteformat$(Ljava/util/Date;)Ljava/lang/String;(F)Ljava/lang/StringBuilder;getCoeficienteAngulargetCoeficienteLinear!$YZ [\]^`abcdeefghibjklbjmanobpqrbpsrbptrbpuvw* * *7*Y* *** *  * 7*Y*  * *  Y L* M,>6>,2:*Y** :Y:*: W Y : !:  " #$: Y:  % &'( W ) &*( W+:   &,- . /0 W 1 2( W  3Ww4 W+3W+xn,-/N1_2h4678 9:-;<<E=d>m?@ABCDEFGH7Jymjz{ ;|} ds~ N  {-iE /hrGDaAaS  wo * * *7*Y* *** *  * 7*Y*  * *  *Y* ** LYM,5W*6NY:Y:-!:"#7:89 W:9 W;9 W<9 W=9 W>9 W?9 W@9 W9 W6+!:"#$:,ABCC7DEW :,GW,HW,ABCC7IW :,GW,HW,AW,HW,JYKL&,MW,HW,JYNL&,MW,HW,2OW,PW, 47FGknFx,OPRNT_UhWYZ[\]^_8`Ja_btcdefghij l4o7m9n@pGrkunsptwv~wxyz{|}~yz 8"9p ~{{*bsswL**Q*RSj*RTbU*Ux y w3*Vx y wl*V*+R*,W*Qx y*hiklmaw/*xy w>*+x yqrw/* xy w>*+ x ysrw/* xy w>*+ x ytrw/*Wxy w>*+Wx yklw/*Xxy w>*Xx y`aw/*Rxy w>*+Rx yhiw/*Qxy w>*Qx ymaw/*Uxy bw>*#Ux ynob